Nonclustered indexes have the same B-tree structure as clustered indexes, with two significant differences: –The data rows are not sorted and stored in order based on their nonclustered keys. –The leaf layer of a nonclustered index does not consist of the data pages.

(Kalen Delaney) One topic I see discussed frequently in public discussion forums is how to most effectively shrink a database, why it doesn’t always shrink as much as you think it should, and how much overhead is involved. Most of the questions deal with the shrinking of the transaction log, probabl

This article explains how to create a comma delimited column in each row.

If the column list in a CREATE TABLE command is terminated with a comma, as in the following statement: create table CommaTab (cola int, colb char(8),) SQL Server does not flag this as a syntax error.

(Muthusamy Anantha Kumar) When transactional replication is used for high availability purposes, such as if you want the applications to access the replicated server when the primary database server fails, one of the hurdles SQL Server database administrators face when configuring replication is tab

If a stored procedure exits with the @@trancount value that is not the same as when the stored procedure was entered, the following error will occur: Error: 266, Severity: 16, State: 1 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = %ld, Cu

Assume the following scenario: In Microsoft SQL Server 2000, a stored procedure output parameter uses a decimal data type or a numeric data type. When a null value is returned, the setting for the precision and the scale of the data that is returned from the stored procedure output parameter is (38,

(Raman Iyer and Jesper Lind) The concept of cross-sell is familiar to most of us. What your friendly neighborhood McDonald’s salesperson does when you order a cheeseburger is exactly what Amazon.com or buy.com are doing online when you add items to your shopping cart and you get a list of other item

This page provides an overview of the Enterprise Library Data Access Application Block. This is reusable and extensible source code-based guidance that simplifies development of common data access functionality in .NET-based applications.

This article discusses cross language support for Microsoft SQL Server 2000.