|
Summary list of best practices, recommendations, and common issues in the form of a Top 10 list.
-
|
Authors: Thomas Kejser, Denny Lee Contributors: Runying Mao Technical Reviewers: Burzin Patel, Kevin Cox, Peter Carlin, Mark Souza, Richard Tkachuk, Len Wyatt, Lindsey Allen, Prem Mehra, Nicholas Dritsas...
|
|
-
|
Contributors : Stuart Ozer, with Prem Mehra and Kevin Cox Technical Reviewers : Lubor Kollar, Thomas Kejser, Denny Lee, Jimmy May, Michael Redman, Sanjay Mishra Building a large scale relational data warehouse...
|
|
-
|
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 practices that the SQL Server team recommends with...
|
|
-
|
OLTP work loads are characterized by high volumes of similar small transactions. It is important to keep these characteristics in mind as we examine the significance of database design, resource utilization...
|
|
-
|
Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified as having predominately read workloads (e.g. Decision...
|
|
-
|
By Cihan Biyikoglu Technical Reviewers: Lindsey Allen, Peter Scharlock, Burzin Patel, Eric Hanson, Mark Souza, Sanjay Mishra, Michael Thomassy SQL Server 2005 has hundreds of new and improved components...
|
|
-
|
Author: Carl Rabeler Proper cube design, efficient multidimensional expressions (MDX), and sufficient hardware resources are critical to optimal performance of MDX queries issued against a SQL Server 2005...
|
|
-
|
Author: Takayuki Hoshino Contributor: Juergen Thomas Technical Reviewer: Sanjay Mishra SQL Server provides an excellent database platform for SAP applications. The following recommendations provide an...
|
|
|
|
|