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

Read on for more detail on SQL Server Management Studio and management improvements, Resource Governor, Change Data Capture and nonlogged inserts, Data Compression, Backup Compression, index ...

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

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

Microsoft has made some big promises for SQL Server 2008, a major update of its enterprise database product. No precise date has yet been announced for the launch, but the new features have caught the ...

Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...