Deep level technical whitepapers on specific SQL Server best practices.

• Views 318 Comments 1

  Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques Brief Description This best practices white paper discusses three many-to-many query performance optimization techniques, including how to implement them, and the performance testing results for each technique... Posted May 03 2008, 03:29 PM by CarlRabeler with 1 comment(s) Filed under: Analysis Services

• Views 597 Comments 0

  Analysis Services Distinct Count Optimization SQL Server Best Practices Article Published : April 17, 2008 Writer: Denny Lee Contributors: Richard Tkachuk, Akshai Mirchandani, Sasha (Alexander) Berger, Thomas Kejser, Stuart Ozer Technical Reviewers... Posted Apr 17 2008, 05:40 PM by denny.lee with no comments Filed under: Analysis Services, Distinct Count

• Views 1,029 Comments 1

  Database Snapshot Performance Considerations under I/O-Intensive Workloads SQL Server Best Practices Article Published: February 11, 2008 Writer: Sanjay Mishra, Ron Talmage Technical Reviewers: Sunil Agarwal, Peter Byrne, Mark Souza, Prem Mehra, Mike Ruthruff, Burzin Patel, Michael... Posted Feb 11 2008, 04:45 PM by SanjayMishra with 1 comment(s) Filed under: Performance, SAN, SQL, Availability, Capacity, I/O, design, Operations

• Views 568 Comments 3

  Best Practices for Migrating Non-Unicode Data Types to Unicode SQL Server Best Practices Article Published: January 21, 2008 Writer: Kohei Ueda Technical Reviewers: Paul Mestemaker, Michael Redman, Wanda He, Juergen Thomas, Burzin Patel, Peter Scharlock, Michael Wang... Posted Jan 22 2008, 11:25 PM by SanjayMishra with 3 comment(s) Filed under: Performance, SQL, design, Unicode, Data Types, Collations

• Views 570 Comments 0

  Database Mirroring and Log Shipping Working Together SQL Server Best Practices Article Published: January 10, 2008 Writer: Sanjay Mishra Contributors: Prem Mehra, Lindsey Allen Reviewers: Matt Hollingsworth, Juergen Thomas, Mark Souza, Burzin Patel, Tom... Posted Jan 21 2008, 05:26 PM by SanjayMishra with no comments Filed under: Availability

• Views 582 Comments 1

  Scale-Out Querying with Analysis Services SQL Server Best Practices Article Published: June 13, 2007 Writers: Denny Lee, Nicholas Dritsas Contributors: Lubor Kollar, Lindsey Allen This white paper describes how to set up a load-balanced scalable... Posted Dec 16 2007, 01:08 PM by denny.lee with 1 comment(s) Filed under: Analysis Services, Querying, Scalability

• Views 232 Comments 0

  The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode SQL Server Best Practices Article Published: November, 2007 Writers: Akio Jose Technical Reviewers: Don Vilen, Fernando Caro, Goldie Chaudhuri, Michael Wang, Sanjay Mishra, Stuart Ozer When a business... Posted Dec 16 2007, 12:59 PM by admin with no comments Filed under: Unicode, Data Types, Collations

• Views 361 Comments 0

  Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services SQL Server Best Practices Article Published: August, 2007 Writers: Carl Rabeler, Eric Jacobsen Technical Reviewers: Craig Utley There are a variety of things that you can do to improve the performance... Posted Dec 16 2007, 08:56 PM by admin with no comments Filed under: Performance, Analysis Services, Querying

• Views 330 Comments 0

  XML Best Practices for Microsoft SQL Server 2005 Microsoft SQL Server 9.0 Technical Articles Published: April 2004, Revised April 2007 Writers : Shankar Pal, Vishesh Parikh, Vasili Zolotov, Leo Giakoumakis, Michael Rys Learn about the guidelines for... Posted Dec 16 2007, 08:53 PM by admin with no comments Filed under: XML

• Views 187 Comments 0

  Performance Optimizations for the XML Data Type in SQL Server 2005 Microsoft SQL Server 9.0 Technical Articles Published: December 2005 Writers : Shankar Pal, Babu Krishnaswamy, Vasili Zolotov, and Leo Giakoumakis This paper explores several ideas to improve the query... Posted Dec 16 2007, 08:50 PM by admin with no comments Filed under: Performance, XML

• Views 321 Comments 0

  SQL Server 2005 Security Best Practices - Operational and Administrative Tasks SQL Server Best Practices Article Published: March 13, 2007 Writers : Bob Beauchemin, SQLskills Technical Reviewers : Laurentiu Cristofor, Al Comeau, Sameer Tejani, Devendra Tiwari, Rob Walters, Niraj... Posted Dec 16 2007, 08:45 PM by admin with no comments Filed under: Security, Operations

• Views 275 Comments 0

  Comparing Tables Organized with Clustered Indexes versus Heaps SQL Server Best Practices Article Published: May 25, 2007 Writers : Burzin Patel, Sanjay Mishra Contributors : Kohei Ueda, Michael Thomassy Technical Reviewers : Stuart Ozer, Prem Mehra, Sunil Agarwal... Posted Dec 16 2007, 08:41 PM by admin with no comments Filed under: SQL, Index, Heaps

• Views 170 Comments 0

  Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios SQL Server Best Practices Article Published: April 30, 2007 Writers : Carl Rabeler Technical Reviewers : Craig Utley This article identifies the top 10 connectivity scenarios in which users may experience... Posted Dec 16 2007, 08:33 PM by admin with no comments Filed under: Analysis Services, Connectivity

• Views 217 Comments 0

  Implementing Application Failover with Database Mirroring SQL Server Best Practices Article Published: April 19, 2007 Writers : Michael Thomassy, Sanjay Mishra Technical Reviewers : Prem Mehra, Mike Ruthruff, Don Vilen, Kevin Cox, Chris Lee, Siva Raghupathy,... Posted Dec 16 2007, 08:30 PM by admin with no comments Filed under: Mirroring, Failover

• Views 337 Comments 0

  OLAP Design Best Practices for Analysis Services 2005 SQL Server Best Practices Article Published: March 21, 2007 Writers: Matt Carroll Contributors: Robert Zare, Edward Melomed, Akshai Mirchandani, Marius Dumitru, Siva Harinath Technical Reviewers: Craig... Posted Dec 16 2007, 08:25 PM by admin with no comments Filed under: Analysis Services, design