SqlServer: May 2009 Archives

I've seen code in pre-Sql Server 2005 (i.e. 2000) where PIVOT-esque functions were carried out and my god were they complicated, messy, HORRID beasts. Put quite bluntly, if I never have to see that code again it'll be far too soon.

I was only reminded of this by coming across a post by Dan Wahlin titled "Pivots to the Rescue - Providing Flexible SQL Server Queries" that gives a good explanation and use-case for them. Something that I'm sure I'll find a use for in the near future!

One of the useful system stored procedures in Sql Server is the sp_spaceused sproc for, funnily enough, seeing how much space a table or database is using. I recently found a MySql equivalent in the MySql Forums, 'Stored procedure for reporting database/object storage usage'.