Browse by Tags

• Analysis Services
• cache
• Development & Programming
• Development &amp
• ETL
• Manageability & Serviceability
• Manageability &amp
• Migration and Transition
• query performance
• Recommended Links
• Reliability and Availability
• Resource Utilization
• Serviceability
• SQL Analysis Service

• New Version of Partition Management Utility Available

  I’m happy to announce availability of an updated version of the SQL Server Partition Management tool – now offering full support for SQL Server 2008 as well as improvements in handling SQL Server 2005. The tool is available along with source code at http://www.codeplex.com/SQLPartitionMgmt Read More... Posted Tuesday, February 24, 2009 7:19 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Manageability & Serviceability, ETL

• SQL Server Scale Out

  After a few recent conversations with CIO and CTO types, I was amazed that there is still the concept out there that SQL Server doesn’t scale well. So I sat down to write a lengthy blog to dispel that rumor. After doing some research, I found that there Read More... Posted Thursday, June 12, 2008 9:00 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Recommended Links

• New Best Practices Whitepaper published: "Best Practices for Migrating Non-Unicode Data Types to Unicode"

  The database system in a company that is growing internationally must support multilingual characters in tables with Unicode data types. Existing d atabases that support only non-Unicode information must be migrate d from non-Unicode data type to Unicode Read More... Posted Tuesday, January 22, 2008 9:18 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming, Performance and Scalability, Manageability & Serviceability, Manageability &amp, Development &amp

• New Best Practices Articles Published - Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

  Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance Read More... Posted Saturday, December 22, 2007 9:09 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, SQL Analysis Service, Development & Programming, Performance and Scalability, query performance

• SSAS small/big query interaction

  Default SSAS behavior can sometimes result in small queries being slowed down by concurrently running big queries. Recently in working with a customer, we observed the most common queries when run by themselves took about 1 second and some ad-hoc queries Read More... Posted Saturday, October 20, 2007 10:24 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, SQL Analysis Service, Performance and Scalability, query performance

• Using ByAttribute or ByTable Processing Group Property with Analysis Services 2005

  As noted within the Analysis Services 2005 Performance Guide , there are some niche situations where setting the Processing Group property to ByTable provides more optimal processing than the default value of ByAttribute. In a customer scenario, we had Read More... Posted Saturday, October 20, 2007 6:19 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability

• New Best Practices Article

  Scale-Out Querying with Analysis Services Using SAN Snapshots Read More... Posted Thursday, September 13, 2007 5:10 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, SQL Analysis Service, Development & Programming, Performance and Scalability, Reliability and Availability, Manageability & Serviceability, query performance, Manageability &amp, Serviceability

• SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services

  Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services There are a variety of things that you can do to improve the performance of an individual MDX query. To begin, you must identify the source(s) of the performance Read More... Posted Wednesday, August 29, 2007 9:06 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: SQL Analysis Service, Development & Programming, Performance and Scalability, cache

• Performance Analysis Tool - DMVStats

  Tom Davidson wrote: I've been working with database applications for the last 25 years. A particular area of interest for me is SQL Server performance. As part of the Microsoft SQL Server Development Customer Advisory Team (SQLCAT) for the last 7 years, Read More... Posted Friday, July 13, 2007 2:38 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Recommended Links

• SQL Server 2005 Transactional Replication: Benefit of using SubscriptionStreams for low bandwidth, high latency environments

  Author: Bren Newman Introduction When using Microsoft SQL Server 2005 Transactional Replication, the Log Reader Agent reads the log, constructs SQL statements for published articles and posts it to the Distribution database; the Distribution Agent reads Read More... Posted Tuesday, May 08, 2007 7:00 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability, Reliability and Availability, Manageability & Serviceability

• 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

• Best SQL Server 2005 MDX Tips and Tricks - Part 1

  Overview SQL Server’s 2005 Analysis Services has introduced several changes to the MDX queries syntax that can lead to better performance than the equivalent AS 2000 queries. Here is a list of tips and tricks as well as best practices on how to get better Read More... Posted Thursday, October 12, 2006 1:42 PM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: SQL Analysis Service, Development & Programming, Performance and Scalability

• 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

• Load 1TB in less than 1 hour

  OVERVIEW This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. The best time I got was 50 minutes. Hewlett Packard was kind enough to Read More... Posted Saturday, May 20, 2006 6:58 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Performance and Scalability