When should you use a Unique Index and when a Unique Constraint? Imran Mohammed explains, and shows how to handle a column with more than one NULL.
SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example
Table-Valued Parameters in SQL Server 2008 let you pass many rows to a stored procedure without a temp table. I walk through the steps with a Department example.
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.
SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
How do you find which table has a transaction lock and what lock type it is? Imran Mohammed explains it for SQL Server 2000 and 2005, and how to avoid locks.
SQL SERVER – 2005 – Best Practices Analyzer (August 2008)
The August 2008 release of SQL Server 2005 Best Practices Analyzer (BPA) checks your Windows and SQL Server settings against Microsoft best practices.
SQLAuthority News – Tip of the Minute
My personal website has a new Tip of the Minute section that shows a fresh SQL Server tip on every refresh. A few sample tips and a small challenge inside.
SQL SERVER – 2008 – Introduction to Online Indexing Operation
An introduction to online indexing in SQL Server, which lets you create or rebuild an index while the table stays available to your app.