Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

For developers working with SQL Server, few performance tuning techniques are as essential--or as frequently misunderstood--as indexing. Done right, indexing can drastically improve application ...

SQL Server 2008 has been significantly enhanced since the previously released versions. Moreover, the product continues to support Microsoft’s data platform vision of mission-critical enterprise data ...

A small social media poll from Visual Studio guru Mads Kristensen split respondents over whether the IDE should add more database tooling, while the discussion quickly turned to existing SQL project ...