INDEX DEFRAG on SQL SERVER 2005

Defrag all indexes in a database for SQL Server 2005

Query Notifications

Datetime conversion

Using xp_ReadErrorLog in SQL Server 2005

I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very interesting parameters. Adding to some of the articles already on the web that discuss undocumented stored procedures, in this article I will explain my testing, use and some examples of the procedure.

Finding dependencies in SQL Server 2005

Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used.

SQL Server 2005

Simplify SQL Server 2005 queries with a Dates table

Learn what a Dates table is and how to create one, and then try it out for yourself

Rebuild Master

DAC Port

Identity Columns