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!