SQL Server Customer Advisory Team - SQL Server Best Practices

Top 10 Lists

| |

Top 10 Lists

Top Tips for Maximizing the Performance & Scalability of Dynamics AX 2009 systems on SQL Server 2008

Posted over 2 years ago

by Peter
- 7 Comments
Authors: Peter Scharlock, Mark Prazak Reviewers: Kevin Cox, Mike Ruthruff, Norberto Garcia, Sri Srinivasan Introduction: This article summarizes...
Top 10 Lists

Top 10 Performance and Productivity Reasons to Use SQL Server 2008 for Your Business Intelligence Solutions

Posted over 3 years ago

by CarlRabeler
- 10 Comments
Author: Carl Rabeler Reviewers: Mark Souza, Prem Mehra, Lindsey Allen, Mike Weiner, James Podgorski, Donald Farmer, Robert Bruckner, Sanjay Mishra, Lukasz...
Top 10 Lists

Top 10 SQL Server 2008 Features for the Database Administrator (DBA)

Posted over 3 years ago

by Mike Weiner
- 14 Comments
Author: Mike Weiner Contributor: Burzin Patel,Sanjay Mishra Reviewers: Lubor Kollar, Kevin Cox, Bill Emmert, Greg Husemeier, Paul Burpo, Joseph Sack, Denny...
Top 10 Lists

Top 10 SQL Server 2008 Features for ISV Applications

Posted over 4 years ago

by Burzin
- 13 Comments
Author: Burzin Patel Contributor: Kun Cheng Reviewers: Sanjay Mishra, Denny Lee, Mike Ruthruff, Sharon Bjeletich, Mark Souza, Peter Carlin, Hermann...
Top 10 Lists

Six Failover Clustering Benefits Realized from Migrating to SQL Server 2008

Posted over 4 years ago

by Lindsey.allen
- 21 Comments
Author: Joseph Sack Technical Reviewer: Burzin Patel, Juergen Thomas, Lindsey Allen, Justin Erickson SQL Server 2008 failover clustering introduces several...
Top 10 Lists

Top 10 SQL Server Integration Services Best Practices

Posted over 4 years ago

by denny.lee
- 49 Comments
Authors: Thomas Kejser, Denny Lee Contributors: Runying Mao Technical Reviewers: Burzin Patel, Kevin Cox, Peter Carlin, Mark Souza, Richard Tkachuk, Len...
Top 10 Lists

Top 10 Best Practices for Building a Large Scale Relational Data Warehouse

Posted over 4 years ago

by SanjayMishra
- 20 Comments
Contributors : Stuart Ozer, with Prem Mehra and Kevin Cox Technical Reviewers : Lubor Kollar, Thomas Kejser, Denny Lee, Jimmy May, Michael Redman, Sanjay...
Top 10 Lists

Storage Top 10 Best Practices

Posted over 5 years ago

by Lindsey.allen
- 14 Comments
Proper configuration of IO subsystems is critical to the optimal performance and operation of SQL Server systems. Below are some of the most common best...
Top 10 Lists

Top SQL Server 2005 Performance Issues for OLTP Applications

Posted over 5 years ago

by Lindsey.allen
- 21 Comments
OLTP work loads are characterized by high volumes of similar small transactions. It is important to keep these characteristics in mind as we examine...
Top 10 Lists

Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications

Posted over 5 years ago

by Lindsey.allen
- 8 Comments
Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified...
Top 10 Lists

Top 10 Hidden Gems in SQL Server 2005

Posted over 5 years ago

by Lindsey.allen
- 2 Comments
By Cihan Biyikoglu Technical Reviewers: Lindsey Allen, Peter Scharlock, Burzin Patel, Eric Hanson, Mark Souza, Sanjay Mishra, Michael Thomassy SQL...
Top 10 Lists

Analysis Services Query Performance Top 10 Best Practices

Posted over 5 years ago

by admin
- 9 Comments
Author: Carl Rabeler Proper cube design, efficient multidimensional expressions (MDX), and sufficient hardware resources are critical to optimal performance...
Top 10 Lists

Top 10 Best Practices for SQL Server Maintenance for SAP

Posted over 5 years ago

by admin
- 3 Comments
Author: Takayuki Hoshino Contributor: Juergen Thomas Technical Reviewer: Sanjay Mishra SQL Server provides an excellent database platform for SAP applications...