Nerdy Musings  
 Home | Search | Index | About | Consulting Services | Donations | Blog | Contact Get an RSS feed for this site! Right click this button and subscribe with your default RSS reader!
  Site Contents  
  Most Recent Articles  
  Most Popular Articles  
 Database Development 
  Microsoft SQL Server  
  Design Principles  
 Musings 
  Musings  
 Web Development 
  Microsoft ASP.NET  
  Microsoft ASP  
 Windows Development 
  MS Visual Basic  
Microsoft SQL Server Database Development
Using Optional Stored Procedure Parameters

by James H. Byrd

 

Learn how to handle missing and invalid parameters in your Transact-SQL stored procedures.
Using Declarative Referential Integrity in SQL Server

by James H. Byrd

 

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.
Improve GridView Performance by Delegating Paging to SQL Server

by James H. Byrd

 

Use SQL Paging to make your grids so fast that you'll wonder if you really clicked the mouse button.
Find Scripts Quickly in SQL Server Management Studio

by James H. Byrd

 

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

by James H. Byrd

 

This article demonstrates a pattern for coding transactions using Transact-SQL in SQL Server stored procedures.
All Content Copyright 2006-2008 by Logical Expressions, Inc. All rights reserved.
This site powered by the Logical Web Publisher (TM): Fast, easy, and affordable content management