Identity over-use: Surrogate vs Composite keys in SQL Server
The SQL Server ‘Identity’ column is a handy way of ensuring a unique primary key, but I have noticed a tendency for some database designs to over-use it.
Posted on Sunday, September 13th, 2009
Improving ASP.NET Performance: SQL Server Database access
Your database interactions are among the most expensive operations you’ll perform in an web application.There are a number of best practices that you should be following when coding a scalable application for SQL Server – here are some of the rules that I swear by.
Posted on Tuesday, February 12th, 2008
Storing documents as XML in SQL Server 2005
When considering how to store documents in SQL Server database it is worth considering that a database is designed to store data, while a file system is designed for storing files. That said, there will be occasions where you will want to store documents in SQL Server. This isn’t just for the convenience of having everything [...]
Posted on Tuesday, February 12th, 2008