SQL Server Customer Advisory Team - SQL Server Best Practices

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

Featured

Mirroring a Large Number of Databases in a Single SQL Server Instance

Authors : Sanjay Mishra, Prem Mehra Technical Reviewers : Lubor Kollar, Michael Thomassy, Lindsey Allen, Mike Ruthruff, Kaloian Manassiev, Kevin Cox, Thomas Kejser, Mike Weiner, Mark Souza, Joseph Sack, Glenn Berry (SQL Server MVP) Overview A frequently ... More
Whitepapers: Deep level technical whitepapers on specific SQL Server best practices.

Whitepapers

View All rss
View All Articles>
Technical Notes: Deep level technical short papers on specific SQL Server topics

Technical Notes

View All rss
View All Articles>
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
  • 141 Views 0 Comments

    How to Enable RCSI for a Database with Database Mirroring

      Posted by: SQL Server Customer Advisory Team
    • 03-16-2010
    Author: Sanjay Mishra Reviewers: Prem Mehra, Alexei Khalyako, Kun Cheng, Mike Ruthruff, Thomas Kejser, Sunil Agarwal To enable read committed snapshot isolation (RCSI) on a database, one needs to execute the following command: ALTER DATABASE <db_name>...
  • 371 Views 1 Comments

    Enabling Partition Level Locking in SQL Server 2008

      Posted by: SQL Server Customer Advisory Team
    • 03-03-2010
    Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate...
  • 289 Views 0 Comments

    SQL Server 2008 R2 UNICODE Compression – what happens in the background?

      Posted by: SQL Server Customer Advisory Team
    • 03-02-2010
    SQL Server 2008 R2 added a much requested feature: Unicode compression. It addresses the need to compress Unicode strings. It is implemented as part of ROW compression, which was added in SQL 2008. That is; if ROW compression (on SQL 2008 R2) is enabled...
  • 645 Views 0 Comments

    Performance tips of using XML data in SQL Server

      Posted by: SQL Server Customer Advisory Team
    • 03-01-2010
    Author: Kun Cheng Reviewers: Peter Carlin, Mike Ruthruff, Thomas Kejser, Nicholas Dritsas XML data type is usually used to store semi-structured data with great flexibility and query capabilities. It’s a good choice for developing platform agnostic applications...
  • 558 Views 0 Comments

    Full Text Indexing Terabytes of Files with SQL Server and Cloud Storage

      Posted by: SQL Server Customer Advisory Team
    • 02-02-2010
    Author: Darko Sancanin, Nicholas Dritsas Reviewers and contributors: Lubor Kollar, Stuart Ozer, Michael Thomassy Business Case There are currently over 50 million files (over 10 Terabytes of data) that the customer is migrating into a custom project management...
  • 1,038 Views 0 Comments

    Whitepaper About Star Join Optimizations

      Posted by: SQL Server Customer Advisory Team
    • 12-16-2009
    When we talk to Data Warehouse customers – they often raise questions about the star joins improvements SQL Server 2008. Star join is a set of optimizations that provide some interesting performance gains in data warehouse workload. Instead of digging...
View All Articles>
Toolbox: Check out our toolbox of helpful tools and scripts.

ToolBox

View All rss
  • 593 Views 0 Comments

    ASLB Toolkit

    Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson, Steve Pontello, Thomas Kejser The ASLB toolkit...
  • 3,340 Views 0 Comments

    Response Time Analysis using Extended Events

    Contributors: Raoul Illyes, Sanjay Mishra, Jerome Hallmans, Thomas Kejser, Mario Broodbakker This tool demonstrates response time analysis at the session...
  • 2,021 Views 0 Comments

    Restart SQL Audit Policy and Job

    Authors : Ayad Shammout, Denny Lee, Jack Richins As noted within the Reaching Compliance: SQL Server 2008 Compliance Guide (you can also check the sqlauditcentral...
  • 2,707 Views 0 Comments

    SSIS Package For Collecting SSAS DMV Data

    SSIS Package For Collecting SSAS DMV Data at http://www.codeplex.com/SQLSrvAnalysisSrvcs This project on Codeplex includes an SSIS package along with its...
  • 2,889 Views 0 Comments

    SSAS Monitoring Scripts For Management Data Warehouse

    SSAS Monitoring Scripts For Management Data Warehouse at http://www.codeplex.com/SQLSrvAnalysisSrvcs This project on Codeplex includes scripts for creating...
  • 4,152 Views 1 Comments

    SQL Server Partition Management Tool

    SQL Server Partition Management Tool is available at http://www.codeplex.com/SQLPartitionMgmt with source code. This tool provides a set of commands (at...
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. (NOTE: New posts from this team are going directly onto SQLCAT.com!)
Technical Spotlights

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

Check out our presentations, radio, podcasts, and webcasts

PowerPivot blogs from SQLCAT team members:

For more information about PowerPivot, check out the SQLCAT series of PowerPivot postings

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.