10 Must Read T-SQL articles on SQLServerCurry - 2009

This post contains 10 Must Read articles that were published in the year 2009 on SQLServerCurry and contains T-SQL scripts to perform some common tasks on your SQL Server database

List all the Stored Procedures of a Database and their Definitions using T-SQL in SQL Server 2005/2008

Select the Highest value in a Group/Category using SQL Server 2005/2008

Select the Highest and Second Highest value in a Group/Category using SQL Server 2005/2008

RANK() VS DENSE_RANK() With an Example using SQL Server 2005/2008

List All Tables with their Modification date in SQL Server

6 Common Uses of the undocumented Stored Procedure sp_MSforeachdb

8 Common Uses of the undocumented Stored Procedure sp_MSforeachtable

Delete Random Records From a Table Using SQL Server 2005/2008

Find Out The Parameters Of A Stored Procedure in SQL Server 2005/2008

Find the Missing Identity Numbers in SQL Server 2005/2008

To read some more articles on T-SQL, check here

I will also be publishing 10 Must Read article on SQL Administration and BI in the upcoming articles