Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

Also, many attempts at dynamic SQL run into performance problems, and the complexity of simply writing dynamic SQL give a negative impression on dynamic SQL.

OCZ Technology has started offering to beta testers is ZD-XL SQL Accelerator, a card that uses solid state drive (SSD) storage to improve the performance of SQL Server databases.