Earlier today there was a question on SQL Server Central where someone wanted to know what could be causing so many reads on their transaction
The first of our public classes (what we call Immersion Events) in 2010 is now officially open for registrations! We've teamed up with our good
I made them up. Yup. I’m talking about the guidance which is: if an index has less than 1000 pages and is in memory, don’t
This is an interesting performance bug concerning a broken query optimizer rule in 2008. Thanks to Dan Shargel (Twitter) for sending me info on this
2005 SP3 CU6 contains a fix for a corruption bug that can happen after rebuilding an XML index that contains XML elements greater than 8000
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.