In SQL Server 2005, queries over partitioned tables use a single-thread per partition. This can cause performance problems under certain circumstances: On systems with many
This one’s a quickie. In the previous post I explained about database pages – their structure and some page types. Now I’d like to explain
Next up in the Inside the Storage Engine series is a discussion of page structure. Pages exist to store records. A database page is an
November’s going to be a busy month for Kimberly and I! Hot on the heels of SQL Connections in Las Vegas is
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.