When I meet SQL Server professionals, I am always interested to find out if they have deployed the latest version of SQL Server into production yet, if they are using Enterprise Edition, and, if so, ...

The Resource Governor lets you define limits on CPU and memory usage for certain workloads. This is good enough to prevent some traffic jams — like query processes consuming too many resources on an ...

I have been testing SQL Server 2008 and I must admit, I’ve been impressed with the new features. I’ve written about some of the new functionality in past blog entries. One feature that I had not ...

The next preview of SQL Server 2008 supports spatial data types and a new Resource Governor feature is slated to hit in a week or two. The next preview of SQL Server 2008 with new support for spatial ...

If you’ve been managing databases for any length of time, you’ve probably had to contend with the “noisy neighbors” scenario. In this scenario, you have several applications, each with their own ...

Microsoft's SQL Server 202 is getting scalability, performance and diagnostics improvements with the arrival of the latest service pack. The new update comes almost a year and a half after SP2, which ...