Wednesday, November 08, 2006 - Posts

The vardecimal type for the fact table

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!

posted Wednesday, November 08, 2006 5:32 PM by marcorusso with 0 Comments

SQL Server 2005 SP2 - CTP available

Here is available the SP2 CTP for SQL Server 2005.

The what's new document explain that there is an improvement in many-to-many dimension relationships calculations. I will try to evaluate the performance improvement, but unfortunately I'm in the middle of a busy timeframe (next week I will be in Seattle for SQL Pass - if someone want to exchange some opinion face-to-face here, let's contact me directly).

If someone get hands-on experience on many-to-many performance changes, please let me know.

posted Wednesday, November 08, 2006 5:39 AM by marcorusso with 0 Comments