(Muthusamy Anantha Kumar) Microsoft introduced a new operator, INTERSECT, in SQL Server 2005.

(Jayaram Krishnaswamy) The SQLCMD lets you write SQL commands as well as T-SQL statements. It also has many other interesting features. This article explains the features of SQLCMD and shows you how to use them.

(Jayaram Krishnaswamy) Reporting is one of the most important activities of an organization because it provides a specialized and customized view of the data of various forms that live in databases or are stored in archives. The report is useful in making business decisions, scheduling business cam

When you run a query against Microsoft SQL Server 2000 post-Service Pack 3 (SP3) hotfix build 8.00.0988, the query may run more slowly than a query that you run against SQL Server 2000 post-SP3 hotfix builds that are earlier than build 8.00.0988.

(graz) I spend a lot of my time reading through trace files. I’ve started writing a utility called ClearTrace to make this process easier. It summarizes the performance of stored procedures and SQL statements much like Read80Trace does. It has both a GUI and command line version and handes traces fo

(Arthur Fuller) It’s a myth that joins are always tests of equality—they don’t have to be. There are uses for joins based on “less than or equal to” and “greater than or equal to”; I can even think of a case in which a “not equal to” join would be useful. The point is, there are lots of ways to […]

(Grant Fritchey) The company I work is for is implementing a custom system, built in Visual Studio and running against SQL Server 2000, to replace some old mainframe applications. It’s an all new database design that will meet all of the old application data requirements and a whole slew of new ones

(William Pearson) Among the many powerful new features that appear within MSSQL Server 2005 Analysis Services (“Analysis Services”), Key Performance Indicators (“KPIs”) are yet another of the “gap closers” between the Microsoft integrated business intelligence solution (consisting of MSSQL Server Da

Modifies an existing table or view index (relational or XML) by disabling, rebuilding, or reorganizing the index; or by setting options on the index.

When you copy or transfer Microsoft SQL Server 2000 data, you may experience one of the following problems: • You may receive an error message that resembles the following: 2002-11-07 14:53:06.29 spid52 Error: 1203, Severity: 20, State: 1 2002-11-07 14:53:06.29 spid52 Process ID 52 attempting to