SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server
I still hadn't time to install the SP2 CTP but I just read this post and I think it's a very interesting thing! The VARDECIMAL could be an amazing feature!
I encountered several times huges fact tables that have many NUMERIC measures. If the VARDECIMAL is optimized enough, it would save a lot of space. I will try on some real-world scenario after SQL Pass, but please if someone do the same test before, let's contact me!
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Marco Russo (SQLBI)
Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies.
He runs the SQLBI.EU website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on.
Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.