SQL Server Customer Advisory Team
FoxPro to SQL Server migration experience
At first I was going to write a detailed white paper about the conversion effort. But someone has...
Author: Kevin Cox SQL Server Date: 01/25/2008
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...
Author: Sanjay Mishra Date: 01/21/2008
SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!
It's a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL...
Author: PaulMest Date: 01/18/2008
Querying Dimension Members In Analysis Services
Many Analysis Services applications query members to populate a dropdown or find those that match...
Author: richtk Date: 01/15/2008
DB Autoshrink option may introduce high fragmentation
IssueWe have seeing some strange behavior when rebuilding indexes. · Total Fragmentation...
Author: Nicholas Dritsas Date: 01/10/2008
New Best Practices Whitepaper published: "Database Mirroring and Log Shipping Working Together"
Log shipping and database mirroring can work together to provide solutions for high availability and...
Author: Sanjay Mishra Date: 01/10/2008
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...
Author: carl.rabeler Date: 12/21/2007
New Best Practices Whitepaper Published: The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode
When a business grows internationally, its database system must support multilingual characters in...
Author: Sanjay Mishra Date: 12/06/2007
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...
Author: Denny G Lee Date: 10/20/2007
SSAS small/big query interaction
Default SSAS behavior can sometimes result in small queries being slowed down by concurrently...
Author: Eric Jacobsen Date: 10/19/2007
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...
Author: Denny G Lee Date: 10/10/2007
Process only one partition so you can browse the cube
If you want to browse the cube and validate dimensions, hierarchies and calculations using the data...
Author: Nicholas Dritsas Date: 09/25/2007
Using unformatted cell values it may improve query performance
If a report does not use formatted cell values, query time can be reduced. An example is a Reporting...
Author: Nicholas Dritsas Date: 09/25/2007
Create a default measure in AS2005 cubes
In some cases, it is not obvious or easy to create a default measure in AS2005 cubes. In fact, there...
Author: Nicholas Dritsas Date: 09/25/2007
SQLCAT tracks at 2007 SQL PASS
As you may already know from Brian Moran's SQL Server Magazine article "SQLCAT to Offer Six Sessions...
Author: Denny G Lee Date: 09/12/2007
New Best Practices Article
Scale-Out Querying with Analysis Services Using SAN Snapshots
Author: carl.rabeler Date: 09/12/2007
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...
Author: carl.rabeler Date: 08/29/2007
Renaming Olap Databases Issues within Analysis Services
If you are view the XMLA script that is generated for an Analysis Services database, you will notice...
Author: Denny G Lee Date: 07/30/2007
Performance Analysis Tool - DMVStats
Tom Davidson wrote:I've been working with database applications for the last 25 years. A particular...
Author: lingzhuz Date: 07/13/2007
Distributed Partitioned Views / Federated Databases: Lessons Learned
IntroductionThis article contains information about the things we have learned while working with...
Author: Kevin Cox SQL Server Date: 06/20/2007
Inconsistencies when using Drillthrough MDX with Perspectives
Author: Denny LeeContributors: John Desch, Kevin CoxReviewers: Robert Zare DRILLTHROUGH MDX...
Author: Denny G Lee Date: 06/18/2007
Four new best practices articles are available
Four new best practices articles are available at the SQL Server Best Practices site on Technet...
Author: Denny G Lee Date: 06/12/2007
New Best Practices Articles are available (May 2007)
You can check out the three new Best Practices Articles Predeployment I/O Best...
Author: Denny G Lee Date: 06/08/2007
Querying a Database Snapshot
Authors: Sanjay Mishra, Michael Thomassy, Peter Byrne Database Snapshots...
Author: Sanjay Mishra Date: 06/06/2007
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...
Author: Sanjay Mishra Date: 05/07/2007
How to warm up the Analysis Services data cache using Create Cache statement?
GoalThis document describes how to build Create Cache commands. Create Cache for Analysis Services...
Author: Nicholas Dritsas Date: 04/26/2007
Previously committed rows might be missed if NOLOCK hint is used
I received a question from one of our customers about using the NOLOCK hint: can it cause missing...
Author: LuborK Date: 02/01/2007
SQL Server Best Practices Website
https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx
Author: thomasda Date: 12/08/2006
Best SQL Server 2005 MDX Tips and Tricks - Part 1
OverviewSQL Server’s 2005 Analysis Services has introduced several changes to the MDX queries...
Author: Nicholas Dritsas Date: 10/12/2006
OLTP Blueprint - A Performance Profile of OLTP applications
Performance and Tuning Blue PrintsWe will look at different types of applications, how they use...
Author: thomasda Date: 06/23/2006
Load 1TB in less than 1 hour
OVERVIEW This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the...
Author: Kevin Cox SQL Server Date: 05/19/2006
SQL Server Sequence Number
Simulating Sequence Objects in SQL Server Many applications need sequentially incremental number as...
Author: howardy Date: 04/10/2006
Managing Schema Changes (Part 2)
SQLCAT Blog: Managing Schema Changes (Part 2) Question: What are best practices for managing schema...
Author: thomasda Date: 03/31/2006
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...
Author: Kevin Cox SQL Server Date: 03/06/2006
Managing Schema Changes (Part 1)
Question: What are best practices for managing schema changes in SQL Server 2005? What are the...
Author: thomasda Date: 03/01/2006
Partition Elimination in SQL Server 2005
Lubor Kollar Partition elimination is very important when SQL Server executes queries against...
Author: LuborK Date: 02/17/2006
Application Patterns and database performance: Complex Screens
As promised way back in August, here is the first installment of a series of blogs on database...
Author: Kevin Cox SQL Server Date: 02/14/2006
How can SQL Server 2005 help me evaluate and manage indexes?
Question: How can SQL Server 2005 help me evaluate and manage indexes?(1) How can I find out whether...
Author: thomasda Date: 02/13/2006
Achieving Selective Uniqueness in SQL Server Tables
SQL Server development group is repeatedly getting questions, suggestions and requests related to...
Author: LuborK Date: 12/20/2005
How can SQL Server 2005 help me evaluate and manage indexes?
SQLCAT Blog: Question: How can SQL Server 2005 help me evaluate and manage indexes? (1) How can I...
Author: thomasda Date: 12/12/2005
Partitioned Tables, Parallelism & Performance considerations
Q: When querying SS2005 Partitioned Tables, what kind of parallelism should I expect to see and how...
Author: thomasda Date: 11/30/2005
SQL Server 2005 Configuration Blog #2.doc
Prem Mehra and Mike Ruthruff In an earlier blog, Deploying SQL Server 2005 with SAN #1, we addressed...
Author: premm Date: 11/21/2005
Deploying SQL Server 2005 with SAN #3
Prem Mehra and Mike Ruthruff We recommend that prior to deploying SAN in a SQL Server production...
Author: premm Date: 11/17/2005
How can SQL Server 2005 OnLine Piecemeal Restore improve availability?
Question 1: How can SQL Server 2005 OnLine Piecemeal Restore improve availability? Question 2: Can I...
Author: thomasda Date: 10/27/2005
Deploying SQL Server 2005 with SAN #1
Deploying SQL Server 2005 with SAN #1 Prem Mehra and Mike Ruthruff An often asked question is how to...
Author: premm Date: 10/11/2005
Obtaining Statement-Level Query Plans
In workloads that involve expensive long-running queries and reports, or complex batch operations,...
Author: Stuart Ozer MSFT Date: 09/23/2005
Using Hashing to Obscure Sensitive Data
At least two customers that I’ve worked with in the past month have been building Data...
Author: Stuart Ozer MSFT Date: 09/16/2005
How do you measure CPU pressure?
It is important to understand whether CPU pressure is affecting SQL Server performance. This is true...
Author: thomasda Date: 09/05/2005
Application Patterns causing poor performance
This series of blogs is a direct response from observing application patterns that can cause poor...
Author: Kevin Cox SQL Server Date: 08/29/2005