October 2006 | Archive by Month | SearchSQLServer.com

October 2006

  • Boost SQL Server data warehouse performance

    Boost SQL Server data warehouse performance with these tips on improving query performance by expert Jeremy Kadlec.30 Oct 2006

  • Speed up SQL Server backup and restore time

    Backup and restore are perhaps the most critical tasks you'll run on SQL Server. They should run in minimal time as they both utilize system resources. In fact, restores require exclusive access to...26 Oct 2006

  • SSIS maintenance plans in SQL Server 2005

    Using SSIS packages for your maintenance plans in SQL Server 2005 allows for greater flexibility to customize tasks and also provides an execution history for less difficult troubleshooting.24 Oct 2006

  • T-SQL and PL/SQL common languages for database-independent applications

    Common languages in T-SQL and PL/SQL exist to allow developers to write applications in database-independent environments. Common languages and interfaces such as ANSI and ODBC offer solutions to t...19 Oct 2006

  • Step 6: Check installations and log file

    Install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles. Contributor Jeremy Kadlec includes the current service pack for the compl...16 Oct 2006

  • Installing SQL Server 2005 Reporting Services

    Install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles. Contributor Jeremy Kadlec includes the current service pack for the compl...16 Oct 2006

  • Step 2: System configuration and registration

    Install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles. Contributor Jeremy Kadlec includes the current service pack for the compl...16 Oct 2006

  • Step 3: Choose components, features and instance types

    Install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles. Contributor Jeremy Kadlec includes the current service pack for the compl...16 Oct 2006

  • Step 1: Determine prerequisites

    Install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles. Contributor Jeremy Kadlec includes the current service pack for the compl...16 Oct 2006

  • Step 5: Begin service pack installation

    Install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles. Contributor Jeremy Kadlec includes the current service pack for the compl...16 Oct 2006

  • Step 4: Final points before installation is complete

    Install SQL Server 2005 Reporting Services with detailed help from this step-by-step guide and avoid any potential hassles. Contributor Jeremy Kadlec includes the current service pack for the compl...16 Oct 2006

  • Disaster recovery in SQL Server: What your plan should look like

    Disaster recovery in SQL Server relies on three components: people, processes and technology. Your failover and failback solutions must minimize SQL Server data loss. Edgewood Solutions' Greg Robid...12 Oct 2006

  • Insert values into IDENTITY column

    I pulled some data in using the import utility in SQL Server and placed it into results. I added a couple columns with default values to match the table to merge with the data. The receiving table ...11 Oct 2006

  • Run SQL 2000 and SQL 2005 instances at the same time

    Can you run SQL 2000 and SQL 2005 instances on the same server? Are there any problems associated with the two instances running together?11 Oct 2006

  • Flat file import not working on 64-bit systems

    Is SSIS on 64-bit systems any different from SSIS on 32-bit systems? I am trying to import a flat file in 64-bit systems, and SQL Server is throwing an exception, yet on 32-bit systems it is workin...11 Oct 2006

  • Efficiently push and pull data in SQL Server

    What is the most efficient way to 'PUSH' data from Sybase to MS SQL Server or 'PULL' data into MS SQL Server from Sybase?11 Oct 2006

  • Problems with structured exception handling

    I recently read your article "Tuning stored procedures: Structured exception handling in SQL Server 2005" and I was trying to implement the concept discussed. It seems the control doesn't enter int...11 Oct 2006

  • Install SQL Server 2000 Enterprise Editon on Windows 2000 Pro

    I'm having a problem installing SQL Server 2000 Enterprise Edition on Windows 2000 Professional. Do I need to install any Service Packs for this?11 Oct 2006

  • Step 1: Scan your SQL Server for malware

    If you don't have anti-virus software installed to protect your SQL Server, then get it on and running as soon as possible. Follow this step-by-step guide to test for a Trojan on your SQL Server.10 Oct 2006

  • Step-by-Step Guide: Test for a Trojan horse on your SQL Server

    SQL Sever sluggishness and other database and operating system woes can mean there's a Trojan horse in your midst. Before you spend countless hours troubleshooting, run these tests to rule out a ma...10 Oct 2006