Browse by Tags

• Analysis Services
• bi
• cache
• Data Warehouse
• Development &amp
• ETL
• integration services
• Manageability & Serviceability
• Manageability &amp
• Migration and Transition
• Performance and Scalability
• query performance
• Reliability and Availability
• Resource Utilization
• Serviceability
• SQL Analysis Service
• ssis

• Using HierarchyID in SQL Server

  Implementing a hierarchy structure in a relational data base normally takes a bit of work. The new SQL Server data type for hierarchyID gives a good shortcut to the old methods, makes it faster to get a solution in place and makes it much easier to maintain. Read More... Posted Friday, August 28, 2009 12:48 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming

• Assigning surrogate keys to early arriving facts using Integration Services

  In data warehouses, it is quite common that fact records arrive with a source system key that has not yet been loaded in the dimension tables. This phenomena is known as “late arriving dimensions” or “early arriving facts” in Kimball terminology. When Read More... Posted Thursday, May 14, 2009 12:26 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming, ssis, bi, integration services, ETL, Data Warehouse

• 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

• Precision Considerations for Analysis Services Users Whitepaper now available

  For those of you whom want to know a little more about precision considerations for Analysis Services users, please check out this recently released whitepaper at http://www.microsoft.com/downloads/details.aspx?familyid=bae8beec-9892-4ecd-a9db-292254895f9c&displaylang=en Read More... Posted Wednesday, October 10, 2007 7:28 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming

• 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

• Inconsistencies when using Drillthrough MDX with Perspectives

  Author: Denny Lee Contributors: John Desch, Kevin Cox Reviewers: Robert Zare DRILLTHROUGH MDX Overview DRILLTHROUGH MDX is a very powerful way to drillthrough to your original data source of detail data that make up the aggregations that you are looking Read More... Posted Tuesday, June 19, 2007 9:13 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming

• 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

• SQL Server Sequence Number

  Simulating Sequence Objects in SQL Server Many applications need sequentially incremental number as unique/primary key of records. SQL Server 2005 today supports identity column as the primary mean to general sequence number, which generates the sequence Read More... Posted Tuesday, April 11, 2006 8:32 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming, Migration and Transition

• Managing Schema Changes (Part 2)

  SQLCAT Blog: Managing Schema Changes (Part 2) Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: In Part 1, we outlined the behavior of SQL Read More... Posted Saturday, April 01, 2006 2:10 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming, Performance and Scalability, Manageability & Serviceability

• 2. Application Patterns and database performance: Academically correct object modeling.

  Another pattern that can cause too many round trips to the database is when each object is treated as a black box and is responsible for retrieving and saving its own data. This by itself is not the problem; it’s when the object hierarchy reaches three Read More... Posted Tuesday, March 07, 2006 9:19 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming

• Managing Schema Changes (Part 1)

  Question: What are best practices for managing schema changes in SQL Server 2005? What are the fastest, least intrusive techniques for high availability? Answer: A common requirement as business requirements evolve over time is managing schema changes. Read More... Posted Thursday, March 02, 2006 7:22 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Development & Programming, Performance and Scalability, Manageability & Serviceability