SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.
 

 
Top 10 Lists: Review our summary list of best practices, recommendations, and common issues.

Top 10 List

View All rss
View All Articles>
SQLCAT Blog Mirror: Review our tips and tricks from enterprise customer lessons learned; mirrored from our SQLCAT Blog at http://blogs.msdn.com/sqlcat.

Blog

View All rss
  • 774 Views 0 Comments

    Fast ordered delete

      Posted by: SQL Server Customer Advisory Team
    • 05-20-2009
    We have a visit from MySpace database team in our lab this week. I have used this opportunity and asked Kevin Stephenson, MySpace’s Senior Database Developer, about “pain points” he encounters while doing his everyday job supporting SQL Server. He brought...
  • 785 Views 1 Comments

    Assigning surrogate keys to early arriving facts using Integration Services

      Posted by: SQL Server Customer Advisory Team
    • 05-13-2009
    In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When...
  • 664 Views 0 Comments

    Proper partitioning can improve dramatically the writeback process when dealing with large data sets

      Posted by: SQL Server Customer Advisory Team
    • 04-15-2009
    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...
  • 475 Views 0 Comments

    SQL Resources for Compliance

      Posted by: SQL Server Customer Advisory Team
    • 04-15-2009
    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...
  • 588 Views 0 Comments

    Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys

      Posted by: SQL Server Customer Advisory Team
    • 03-31-2009
    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...
  • 894 Views 0 Comments

    Useful links for upgrading to SQL Server 2008

      Posted by: SQL Server Customer Advisory Team
    • 03-27-2009
    There is plenty of material available to help you upgrade to SQL Server 2008. This blog is intended as a short list for the most useful guidance that I have found. And you may have different experiences upgrading from SQL Server 2000 and SQL Server 2005...
View All Articles>
Technical Notes: Deep level technical short papers on specific SQL Server topics

Technical Notes

View All rss
View All Articles>
Whitepapers: Deep level technical whitepapers on specific SQL Server best practices.

Whitepapers

View All rss
View All Articles>
Toolbox: Check out our toolbox of helpful tools and scripts.

ToolBox

View All rss
View All Articles>

Resources

CSS Experts Blog: Great SQL Tips and Best Practices from SQL Escalation engineering team

SQLCAT ISV Team blog: Great SQL tips and best practices from the SQLCAT ISV team
Technical Spotlights

Check out our technical end-to-end studies on customer implementations
Presentations

Check out our presentations, radio, podcasts, and webcasts
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
Search
Sign In

Recent Posts

Other Languages

Popular Tags

 
CAT | Customer Advisory Team | Meet the members of the largest SQL Server implementation team.
Copyright 2008 Microsoft Corporation. All Rights Reserved.