Browse by Tags

• Development & Programming
• Manageability & Serviceability
• Migration and Transition
• Performance and Scalability
• Reliability and Availability
• SQL Analysis Service

• SSAS Partition Slicing

  Summary: SSAS uses partitions to contain cube data. Small cubes might use only one, but for non trivial cubes, cube designers will create partitions based on ease of managing data and to split groups of data. This document discusses how the server uses Read More... Posted Tuesday, March 06, 2007 12:10 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: SQL Analysis Service, Resource Utilization, Development & Programming, Performance and Scalability

• Check out the exciting new SQL Server Best Practices website.....

  http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise Read More... Posted Saturday, December 09, 2006 8:31 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Resource Utilization, Development & Programming, Performance and Scalability, Migration and Transition, Reliability and Availability, Manageability & Serviceability

• OLTP Blueprint - A Performance Profile of OLTP applications

  Performance and Tuning Blue Prints We will look at different types of applications, how they use resources, and how one would approach performance tuning each. The performance profile of OLTP differs significantly from a Relational Data Warehouse or Reporting Read More... Posted Saturday, June 24, 2006 4:34 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Resource Utilization, Performance and Scalability