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!

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2006/11/08/the-vardecimal-type-for-the-fact-table.aspx