After you upgrade to Microsoft SQL Server 2000 post-Service Pack 2 (SP2) or a later build including SQL Server 2000 SP3, a query may take a much longer time to run, even though the query runs in seconds in SQL Server 2000 SP2. This problem occurs if both the following conditions are true: • The

(Serdar Yegulalp) SQL Server’s Data Transformation Services (DTS) can convert data to and from a variety of formats, either for use within SQL Server or to export SQL Server data to another program. One common form of data for import is an Excel spreadsheet, since Excel is in essence a sort of datab

(Tom Pullen) This article provides how-to information and code for two different monitoring systems you can set up centrally to manage reporting of SQL Server 2000 maintenance and disk utilization. The first is a scheme I have used in my role as a DBA, which has helped simplify and speed up one

When your computer that is running Microsoft SQL Server 2000 performs a very large hash operation, an error message that is similar to the following may be logged many times to the SQL Server error log: Date Time server Error: 17883 Severity: 1, State: 0 Date Time server Process 52:0 (94c) UMS

(Ken Henderson) This article explains the effects that SQL Server fiber mode coupled with the User Mode Scheduler component can have on your system, and what to consider carefully before enabling fiber mode.

(Chris Sully) Sql Server reporting services provides the means to design, author, render and deploy business reports via the web.

When you perform a bulk insert operation in Microsoft SQL Server 2000, the transaction log file becomes corrupted and error 3624 is written to the SQL Server error log. Subsequently, the user database is marked suspect.

(Andrew Novick) I’ve been writing a lot of .Net code in the last couple of years and have become enamored of the TRACE capability that’s built in to .Net. The TRACE object lets the programmer add lines of trace output to any program through the TRACE.WRITELINE method. Trace messages are sent to on

(William E. Pearson, III) To get the most out of the Optimizing MSSQL Server Reporting Services series, we need to have installed Microsoft SQL Server 2000 Reporting Services, together with Microsoft Visual Studio.NET (required to access Report Designer for report creation). Reporting Services ships

When you perform large in-memory sort operations in Microsoft SQL Server 2000, SQL Server may not yield to the SQL Server User Mode Scheduler (UMS). This behavior could lead to stalled worker requests. When this problem occurs, connection timeouts and other time-sensitive operations may fail. When t