Learn how to save time and prevent permission configuration problems when you move a SQL Server database from one computer to another.
Improve GridView Performance by Delegating Paging to SQL Server
November 13, 2010 by
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.
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.
