Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.

April 2009 - Posts

Proper partitioning can improve dramatically the writeback process when dealing with large data sets
Proper partitioning can improve dramatically the writeback process when dealing with large data sets Author: Nicholas Dritsas Reviewers: Richard Tkachuk, Akshai Mirchandani CASE : Customer is using SQL 2008 and SSAS's writeback abilties to do 52-weeks Read More...
Posted: Thursday, April 16, 2009 2:05 AM by Nicholas Dritsas | 2 Comments
SQL Resources for Compliance
Author : Denny Lee Reviewers : Prem Mehra, Kevin Cox With the terabytes of data that are being stored today - truly representing the data explosion that we've always talked about - it's becoming more and more difficult to provide an audit trail or utilize Read More...
Posted: Wednesday, April 15, 2009 10:06 PM by denny.lee | 1 Comments
Filed under: ,
Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys
Author: Nicholas Dritsas Reviewers: Thomas Kejser, Stuart Ozer In SSAS 2005 and later, there is a dimension property called ProcessingGroup. It has two values; ByAttribute (default) and ByTable. When you use ByAttribute, SSAS will send a SELECT DISTINCT Read More...
Posted: Wednesday, April 01, 2009 1:48 AM by Nicholas Dritsas | 1 Comments
Page view tracker