In Microsoft SQL Server 2000, when you run a large and complex query plan that uses hash operators, you may experience delays when SQL Server 2000 compiles and optimizes the plan for the query. You may also receive a 17883 error message in the SQL Server 2000 error log that is similar to the followi

This article will teach you the basic techniques used to find and fix poorly performing SQL statements (usually SELECT statements, but also INSERT, UPDATE and DELETE statements) on Microsoft’s SQL Server 2000 relational database management system. (R)

(Arthur Fuller) Recursion is one of the most elegant programming constructs in my opinion. I have used it in dozens of situations and in several programming languages. The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached.

(Serdar Yegulalp) When a database administrator creates a database in SQL Server, he can control how the database’s filegroups (the physical files that contain the database) are sized initially and then resized later over time. The way resizing is handled can be done either by percentage or by n

When you use the SqlClient class in a Microsoft .NET Framework client application to work with Microsoft SQL Server 2000 hotfix build 2000.80.811 or a later version, you may receive an error message if the following conditions are true: • Your application tries to call a stored procedure. • The

Few things are worse than rolling out a new application and its performance is so bad that it brings the business to a screeching halt. This is not a new phenomenon; it’s a reality that I have seen from time to time. I am willing to bet that you have experienced it, too. So what is the solution for

(William Pearson) In this article, we will examine the processing of an Analysis Services cube via another of the integrated MSSQL Server components, Data Transformation Services (“DTS”). Virtually anyone that works with MSSQL Server in an RDBMS context, and often within a data warehouse or mart des

(Justin Y. Shi) It has become a moot point for database vendors to compete for the highest transaction processing capability in the world. Modern database systems have become so well programmed; even the cheapest system can claim very high performance, given the hardware.

In Microsoft SQL Server 2000, when you try to back up a database that is stored on read-only media such as a read-only CD, you receive the following error message: Server: Msg 3624, Level 20, State 1, Line 1 Location: “logtrunc.cpp”:337 Expression: stLSN != NullLSN SPID: 57 Process ID:

(Teo Lachev) This article explains the major components of Microsoft Reporting Services’ ad-hoc architecture and semantic model, and walks you through an end-to-end example that demonstrates how to author, manage, and deliver ad-hoc reports.