Use SQL Paging to make your grids so fast that you’ll wonder if you really clicked the mouse button.
Using Optional Stored Procedure Parameters
February 7, 2010 by
Learn how to handle missing and invalid parameters in your Transact-SQL stored procedures.
Using Declarative Referential Integrity in SQL Server
August 9, 2009 by
The next time you are designing a new application database or adding new tables to an existing database, take a few moments to think about how you can leverage the DRI features of SQL Server to make your development life a little easier.
Find Scripts Quickly in SQL Server Management Studio
February 2, 2008 by
You’ll love this tip if you are tired of navigating all over your hard drive to find your scripts from inside SQL Server Management Studio.
Coding Transactions in Transact-SQL
July 27, 2007 by
This article demonstrates a pattern for coding transactions using Transact-SQL in SQL Server stored procedures.
