Microsoft SQL Server 2005 Service Pack 2 was released today. Why do you care? Well, if you’re using the Enterprise version, you now have a new data type – vardecimal. It’s the same concept as varchars and it can save a lot of disk space if you’re storing low-precision numbers in high-precision columns. There’s even a new system proc that will estimate the space you’d save if you switched to the new type!

Advertisements