When you run a Transact-SQL query in Microsoft SQL Server 2000, you may receive incorrect results. You experience this problem when all the following conditions are true: • The query contains an inner join that has a one-to-one key relationship. • The query contains an aggregate expression or a

(george.p.alexander) Sometimes overlooked and innocently missed during the development phase of a project is the existence of poor SQL queries. There can be various excuses for getting poor performance queries. But it won’t be unusual if you find somewhere during the programming life that end users

When studying relationships, we reviewed techniques of making data from one table available to the records of another table. This demonstrated to reduce data duplication and mistakes. Another issue that involves the combination of tables consists of creating records from more than one table and maki

(Jamie Thomson) The OLE DB Source component allows a number of methods for extracting data from an OLE DB Source. The two most obvious are: 1) Write a SQL statement to extract data 2) Select a required table from a drop down box.

(george.p.alexander) The power of getting the right index for your query is absolutely amazing. I was doing some checking on this test environment that was set up and had this Stored Procedure that takes around 4 minutes and 35 seconds. Our UAT guys wanted the thing to perform in a jiffy. Performanc

(Don Kiely) The ability to write stored procedures and other code modules in C#, VB, or any other .NET language has long been one of the most enticing features in what was then the upcoming SQL Server 2005. Both developers and DBAs are finally able to break the shackles of Transact-SQL (T-SQL) and C

(Adam Machanic) Ever want to find out which connections running T-SQL are blocking other connections? Sure, you could run sp_who or query the syslockinfo table, but what if you wanted more information to help debug the problem? For instance, how would you determine which T-SQL the blocking process w

(Gregory A. Larsen) Server 2005 now supports a more programmable error trapping convention in T-SQL code. This error handling is known as the TRY/CATCH block. The TRY/CATCH block allows T-SQL to handling errors like other programming languages, such as Microsoft Visual C# and C++. In addition to the

This article describes how to build an OLE DB application for Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE) in Microsoft Visual Studio 2005. This article uses the NorthwindOleDb sample application that is installed with Visual Studio 2005 in an example.

(Muthusamy Anantha Kumar) When a new version is released or when existing software is upgraded there is always a learning curve and getting used to new ways of doing things. This article demonstrates how to use SQL Server 2005’s catalog views in comparison with using system tables in SQL Server 2000