When you join local partitioned views with a table in Microsoft SQL Server 2000, SQL Server produces an inefficient query execution plan. The inefficient query execution plan causes poor performance. See the More Information section underneath for a demonstration of reducing the partition view t

(Rick Dobson) Many believe that the absence of graphical client management tools for MSDE hampered its widespread adoption, but with the December 2004 and subsequent Community Technology Preview (CTP) releases of Express Manager (XM), Microsoft offers a solution that works not only with MSDE and oth

In Microsoft SQL Server 2000 Reporting Services, when you try to run a stored procedure by using the Data view in Report Designer, you receive an error message that is similar to the following: An error occurred while executing the query. Procedure or function yourStoredProcedure has too many ar

(Erika Ehrli Cabral) Many applications have components that connect, manage, and consume data from a database. If you are designing/building an application that connects to a database to continuously insert, update or delete data, you should keep in mind that each operation will need a round-trip to

(Jeremy Kadlec) In late March 2005, the first installment of SQL Server Performance-Tuning worst practices was released, and people in the community responded to the article with other worst practices they have observed. In this installment, we will explore some new observations and provide recommen

(Steven Warren) In SQL Server 2000, the SQL Profiler can help you diagnose and fix SQL Server performance issues. This tool lets you trace events and play back the results, which can help you determine application and/or query problems, such as long-running queries or ineffective indexes. Let’s

(graz) In Part 1 I covered a simple stored procedure that printed the current date. In this article I’ll cover writing a stored procedure to return a recordset back to the client. In the process we’ll learn a little bit more about .NET and C# including the SqlConnection, SqlCommand and SqlDataReader

Microsoft SQL Server is growing in terms of market share and revenue. Adhering to data lifecycle management techniques to automate and streamline processes can help you be successful on the Microsoft SQL Server platform. (R,pdf)

(Brian Walker) The SQL code in Listing 1 (below) creates a system stored procedure named sp_ListFiles. The routine returns a filtered list of files found in a specified directory. The sp_ListFiles stored procedure uses the xp_cmdshell extended stored procedure that comes with SQL Server. (R)

In Microsoft SQL Server 2000, when you use a CASE function that contains a subquery for the THEN expression, the subquery is evaluated even if the condition in the WHEN expression is false.