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 ...

We have only discussed a couple of the potential problems caused by bad data types. In general, it is best to assign your columns the data type (and length) that best matches the values in its domain.

When you use index views in the right situations, they can dramatically improve the performance of SQL Server queries. Tim Chapman explains why performance testing is the best way to tell if ...