However, I did find an algorithm for calculating Easter for...
Handy Script Helps Analyze Database StructuresCommented on: 9 years ago
(March 29, 2005)
Nice to see these kinds of utilities being shared. (Every DBA and developer should have a toolbox full of similar scripts.)
I'm surprised, though, to see it written using system tables instead of...
Pivot (or Unpivot) Your DataCommented on: 10 years ago
(July 20, 2004)
Stefano: you could definitely use my spTranspose. A call like this would let you do what you want using Ben-Gan's test data, you just have to change the WHERE clause in the @Query parameter:
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More