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

What does your view look like? SQL Server doesn't like inserting values into "complex" views, iirc.

The move from Microsoft SQL Server 2000 to 2005 was a big leap with many new functionalities and features introduced. The concept of DDL Triggers was one such new feature.

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even ...