Given that SQL Server workloads are commonly I/O bound, a great way to get a sense for how a given server is keeping up with its current workload is to evaluate how long the I/O subsystem is taking to respond to requests by SQL Server to read or...
Deadlocks have received a large amount of coverage—in a wide variety of resources.
Related: Gathering Deadlock Information with Deadlock Graph
As such, the point of this post isn’t to call out anything special about debugging, tracki...
Nested stored procedures (or stored procedures that call other stored procedures) are a mixed blessing and a curse. They also serve as powerful fodder for starting holy wars. On the one hand, they serve as a great means for allowing developer...
In the past I've blogged a bit about the importance of enabling your SQL Servers to be pro-active in terms of alerting you via email when something bad has happened or requires attention. I've also addressed a very common 'gotcha' that preve...
Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf...
My family recently just 'officially' announced that we’re in the process of adopting a child from South Africa...