Here are some oldies, but goodies that I recommend you read: Two Partitioning Peculiarities and Aggregates and Partitioning Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads. However, there Read More...

It seems like questions always come up about how to monitor memory. But each time the question comes up, it’s slightly different. Here’s a sort of FAQ for memory questions: 1. How can I figure out memory and CPU consumption by database? a. In SQL Server Read More...

I find that auto_update statistics in SQL Server is a really good thing. Without it, many third-party applications would simply fall over from lack of preventative maintenance. W ith it, they are able to run for extraordinarily long periods of time without Read More...

You might encounter a situation, under a very heavy workload, where processing for certain transactions starts out very efficiently, but over time becomes much less efficient. A good place to start troubleshooting is, of course, PerfMon. But PerfMon can Read More...