Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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