Removing Duplicate Records

How to remove duplicate records from a table.

Changing a Non-IDENTITY column to IDENTITY and vice versa

This article from new author Thomas Pieries, brings us a few methods for changing a Non-IDENTITY column to IDENTITY and vice versa as well as examining the advantages and disadvantages of each way.

User Defined Function Execution

Computed Columns

Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.

Dump

Remote Synonyms

Table Variables

DBCC Reindex with Statistics Information and table name optional

Reindex all tables, showing statistics before and after reindexing, table name optional.

Synonyms

Revenge of the BLOB

Working with large images or other BLOB data can be a challenge for many DBAs. Andrew Sears brings us some code that can help you extract some of that data out of BLOBs and get it back into a more easy-to-work-with format.