Browse by Tags

• Analysis Services
• Manageability & Serviceability
• Manageability &amp
• Performance and Scalability
• Reliability and Availability
• Serviceability
• sql
• SQL Analysis Service
• SQL Server
• SQL Server Best Practices

• Character data type conversion when using SQL Server JDBC drivers

  In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise to identify the most expensive Read More... Posted Tuesday, April 06, 2010 7:49 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: sql, SQL Server, Development & Programming, Performance and Scalability, query performance, SQL Server Best Practices

• 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

• 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