February 2007 | Archive by Month | SearchSQLServer.com

February 2007

  • Enhance your SQL Server security skills with five quick steps

    Rock solid secure database systems require sharp skills on behalf of a SQL Server DBA. You need to keep up with everything from new Microsoft features, to a good amount of programming logic. IT se...28 Feb 2007

  • FAQ: DTS packages in SQL Server

    Since the release of SQL Server 2005, the spotlight has been on SQL Server Integration Services (SSIS) as it is the new and powerful ETL tool (short for extraction, transforming and loading). SSIS ...26 Feb 2007

  • More powerful Analysis Services MDX in SQL Server 2005

    MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language.24 Feb 2007

  • T-SQL in SSIS: The power and the weaknesses

    Using T-SQL vs. the Data Flow task in SQL Server Integration Services (SSIS) is a decision dependent on a number of factors. Serdar Yegulalp shares some things to consider, including data origin, o...23 Feb 2007

  • CASE statements now supported by MDX script in SQL Server 2005

    MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language.23 Feb 2007

  • Top 5 SQL Server query tips

    SQL Server queries should guide you toward successful, trouble-free data retrieval. Our SQL Server experts have written tips on troubleshooting queries, to tips on how to run queries in Analysis S...21 Feb 2007

  • SQL Server .VHD trial editions that impress

    Virtualization in Microsoft Windows has made it possible to create SQL Server trial versions in the form of standalone virtual machines. These are distributed in Microsoft's Virtual Hard Drive or ....21 Feb 2007

  • SQL Server 2005 backup and recovery: 5 handy tips

    Backup and recovery with SQL Server 2005 include several new features worthy of your attention. These features include database mirroring and database snapshots, which have been hailed as "gems" in...19 Feb 2007

  • Update table rows in SQL Server 2000

    How can I update the first row of a group? I have a table like this structure: col1 col2 1 row1 * 2 row1 3 row1 4 row2 * 5 row2 6 row2 I w...16 Feb 2007

  • Syntax error in SQL Server script

    I'm currently working on table partitioning. I'm struggling with using this " SELECT MAX(NAME) from sys.filegroups WHERE NAME NOT LIKE 'PRIMARY' " in order to get the last used Filegroup. Now this ...16 Feb 2007

  • Utility to dump SQL Server Express database as text file

    I want to dump my SQL Server Express database as a SQL Server text file including "create table and index statements, and "insert into ... statements for all tables." Postgres has such a utility c...16 Feb 2007

  • Conversion error in SQL Server business objects

    While working with business objects in SQL Server I am getting the error "conversion of char data type to datetime data type resulted in an out of range datetime value." What is the problem?16 Feb 2007

  • DTS package designed to overwrite extract.xls

    I have a DTS package that produces an output file called extract.xls. Every time the package runs, the output is appended to the extract.xls file. How can I design the DTS package to overwrite or d...16 Feb 2007

  • Calling a stored procedure remotely

    I'm using an ASP (Active Server Page) to call a stored procedure on a remote SQL Server. It's not executing, instead it's stalling. When my Web server and SQL Server are on the same machine I don't...16 Feb 2007

  • Delete .bak files automatically with CLR

    I have a query and I want to know if there is a stored procedure, SQL script, or T-SQL script to delete the .bak files, which are older than seven days. I have set up daily backups and after the da...16 Feb 2007

  • Stored procedure overview in SQL Server

    How can I get an overview of all stored procedures and the tables they use?16 Feb 2007

  • Conversion of char data type error

    I received this error: "XP and VS2003 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." The same page under Server 2003 works well. I need to...13 Feb 2007

  • Installing two instances of SQL Server 2005 on same server

    Can you install two instances of SQL Server 2005 on the same server?13 Feb 2007

  • Special data types-Part 1

    In book excerpt, special data types are defined, including: timestamp, uniqueidentifier, and cursor and xml data types, a major new feature in SQL Server 2005. User defined data types are also expl...07 Feb 2007

  • Transact SQL cursors

    T-SQL cursors are used to repeat custom processing for each row of the cursor. The following excerpt outlines how to process a cursor for Transact-SQL Server and gives an example.07 Feb 2007