Using BCP to export the contents of MAX datatypes to a file

Phil Factor presents a poetic stored procedure for storing any VARCHAR(MAX) to file.

You are having issues with queries running strangely...

Delete Duplicate Records without using Cursor

This script will delete the duplicate records without using cursor

Performance problem in SQL Server 2005

I have written stored procedure which simply read each row one by one and update the some column in same table.SP is running fine in SQL Server 2000 and completed within 5 minutes (around 5 million rows)But same SP in SQL Server 2005, its taking around more than one hour (for same number of rows)Note: […]

The OUTPUT Command

SQL Server 2005 has added many new T-SQL commands, one of which is the OUTPUT command. Longtime SQL Server author Dinesh Asanka brings us a short look at how you can use this command.

In SQL Server 2005, when using the OUTPUT...

Script to simplify maintenance of sysproperties

This procedure will maintain the sysproperties table by wrapping system procedures:                • sp_addextendedproperty                • sp_dropextendedproperty                • sp_updateextendedproperty            The parameters are:                • @object    --    primary name of the object being to be maintained.                • @column    --    column or parameter […]

Script to simplify maintenance of sysproperties

This procedure will maintain the sysproperties table by wrapping system procedures:                • sp_addextendedproperty                • sp_dropextendedproperty                • sp_updateextendedproperty            The parameters are:                • @object    --    primary name of the object being to be maintained.                • @column    --    column or parameter […]

Consider the following table:

CREATE TABLE n
(
id INT...

What does the ROLLBACK WORK statement do?