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:
Digital Magazine Archives
Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.
Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More