SQL Server Customer Advisory Team
Enabling Partition Level Locking in SQL Server 2008
Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin...
Author: Thomas Kejser Date: 03/03/2010
SQL Server 2008 R2 UNICODE Compression – what happens in the background?
SQL Server 2008 R2 added a much requested feature: Unicode compression. It addresses the need to...
Author: Peter Scharlock Date: 03/02/2010
Performance tips of using XML data in SQL Server
Author: Kun ChengReviewers: Peter Carlin, Mike Ruthruff, Thomas Kejser, Nicholas Dritsas XML data...
Author: Kun Cheng (SQLCAT) Date: 03/01/2010
Full Text Indexing Terabytes of Files with SQL Server and Cloud Storage
Author: Darko Sancanin, Nicholas Dritsas Reviewers and contributors: Lubor Kollar, Stuart Ozer,...
Author: Nicholas Dritsas Date: 02/02/2010
Whitepaper About Star Join Optimizations
When we talk to Data Warehouse customers – they often raise questions about the star joins...
Author: Thomas Kejser Date: 12/16/2009
Monitoring free space in tempdb transaction log
Author: Thomas Kejser Reviewers: Peter Byrne, Sunil Agarwal, Prem Mehra, Peter Scharlock, Lindsey...
Author: Thomas Kejser Date: 12/14/2009
Performance Comparison between Data Type Conversion Techniques in SSIS 2008
Authors: Sedat Yogurtcuoglu and Thomas Kejser Technical Reviewers: Kevin Cox, Denny Lee, Carl...
Author: Thomas Kejser Date: 12/01/2009
PowerPivot for SharePoint Installation Guides DRAFT
The installation of PowerPivot for SharePoint can be a little complex at times - especially the...
Author: Denny G Lee Date: 11/20/2009
Are you going to SQL PASS Nov. 3rd- Nov. 5th?
Are you going to SQLPASS in Seattle on Nov 3rd-Nov 5th? If you are going or even thinking about it,...
Author: marksou Date: 10/19/2009
Looking deeper into SQL Server using Minidumps
Author: Thomas Kejser Reviewers and Contributors: Bob Ward, Michael Thomassy, Juergen Thomas,...
Author: Thomas Kejser Date: 09/11/2009
Using HierarchyID in SQL Server
Implementing a hierarchy structure in a relational data base normally takes a bit of work. The new...
Author: Kevin Cox SQL Server Date: 08/27/2009
Gemini - Self Service BI!
Gemini is the code name for the new breakthrough Self-Service Business Intelligence (BI)...
Author: Denny G Lee Date: 08/15/2009
Multi user SSAS writebacks may result to blocks on similar functions and new connections.
Author: Nicholas Dritsas Reviewers: Akshai Mirchandani, Kevin Cox, Lubor Kollar, Thomas Kejser...
Author: Nicholas Dritsas Date: 07/22/2009
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...
Author: Thomas Kejser Date: 05/13/2009
Proper partitioning can improve dramatically the writeback process when dealing with large data sets
Proper partitioning can improve dramatically the writeback process when dealing with large data...
Author: Nicholas Dritsas Date: 04/15/2009
SQL Resources for Compliance
Author: Denny LeeReviewers: Prem Mehra, Kevin Cox With the terabytes of data that are being stored...
Author: Denny G Lee Date: 04/15/2009
Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys
Author: Nicholas DritsasReviewers: Thomas Kejser, Stuart OzerIn SSAS 2005 and later, there is a...
Author: Nicholas Dritsas Date: 03/31/2009
Useful links for upgrading to SQL Server 2008
There is plenty of material available to help you upgrade to SQL Server 2008. This blog is intended...
Author: Kevin Cox SQL Server Date: 03/27/2009
Remember to move DTS2000 packages when upgrading msdb from 2005 to 2008
Some customers prefer to upgrade to SQL Server 2008 by detaching all databases from their SQL Server...
Author: Thomas Kejser Date: 03/20/2009
Analysis Services Partition Size
Thomas and I updated the SQL Server 2008 Analysis Services Performance Guide principally to address...
Author: richtk Date: 03/13/2009
SQL Server 2008’s Oracle destination fast load option may fail if certain Oracle system views are missing
Author: Nicholas Dritsas Reviewers: Lubor Kollar, Michael Thomassy, Sanjay Mishra SQL Server...
Author: Nicholas Dritsas Date: 03/03/2009
Using BIDS 2008 to validate Analysis Services 2005 cubes
If you have experimented with cube design in SQL Server 2008, you will probably have run into the...
Author: Thomas Kejser Date: 02/26/2009
New Version of Partition Management Utility Available
I’m happy to announce availability of an updated version of the SQL Server Partition...
Author: Stuart Ozer MSFT Date: 02/23/2009
The Data Loading Performance Guide - Now available from MSDN
By popular request, the SQL Customer Advisory Team has collected our lessons learned about tuning...
Author: Thomas Kejser Date: 02/12/2009
Minimize downtime with DB Mirroring
At one high volume OLTP project we are involved in, the customer likes to use DB Mirroring to...
Author: Kevin Cox SQL Server Date: 02/09/2009
Ultimate guide to upgrading to SQL Server 2008
For the ultimate guide to upgrading to SQL Server 2008, please refer to the SQL Server 2008 Upgrade...
Author: Denny G Lee Date: 12/07/2008
SQL Server 2008 Analysis Services Performance Guide now available
Thomas Kejser and I made some significant updates to the SQL Server Analysis Services Performance...
Author: richtk Date: 11/14/2008
Best Practices for Integrated Full Text Search (iFTS) in SQL 2008
This blog is a result of lessons learned while working with the new Integrated Full Text Search in...
Author: Kevin Cox SQL Server Date: 11/05/2008
12,000 Concurrent Siebel CRM 8.0 Users On SQL Server 2008
Recently, Wanda He from SQLCAT ISV team worked with Oracle Siebel group completed a new 12,000...
Author: lingzhuz Date: 10/29/2008
Reporting Services Scale-Out Deployment Best Practices
[Update 17 Aug 2017: the link below is broken; but you can find the original paper and many more in...
Author: Denny G Lee Date: 10/22/2008
Reintroducing sqlcat.com
Check out the new look and feel of the sqlcat.com! Now you have easy access and views of our Top 10...
Author: Denny G Lee Date: 10/16/2008
Table variable vs. temp table and estimated vs. actual query plan
The other day we got a call from a puzzled friend. He has rewritten a stored procedure using table...
Author: lingzhuz Date: 10/09/2008
Latest Publications: Top 10 SQL Server Integration Services Best Practices and "Money" Technical Notes Published
After the great work from the ETL World Record (for more information, refer to our other blog at:...
Author: Denny G Lee Date: 10/09/2008
SQL PASS 2008 Just may be the best PASS Conference yet
Coming up this November 18-21st is the SQL PASS Conference in Seattle, WA (right in...
Author: marksou Date: 09/25/2008
Scaling Heavy Network Traffic with Windows
Under Windows Server 2000 and 2003 (RTM), the interrupts from a single network adaptor (NIC) cannot...
Author: Thomas Kejser Date: 09/18/2008
Microsoft SQL Server Database Snapshots and Synonyms
OVERVIEW: One of the common complaints in using database snapshots is how to get queries and reports...
Author: Kevin Cox SQL Server Date: 08/05/2008
New Best Practices Articles Published - Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned
Due to the improvements in the Windows Server 2008 memory manager related to the change in the...
Author: carl.rabeler Date: 07/16/2008
New Best Practices Articles Published - Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned
Reporting Services 2008 was able to respond to 3–4 times the total number of users and their...
Author: carl.rabeler Date: 07/16/2008
SQL Server Scale Out
After a few recent conversations with CIO and CTO types, I was amazed that there is still the...
Author: Kevin Cox SQL Server Date: 06/12/2008
What you should know if you are using Logical IOs to measure query plan quality
One of the presenters at recent SQL Server Open World conference in Denmark...
Author: LuborK Date: 04/10/2008
Interesting observation with table > 1TB
Interesting observation with table > 1TBWe have a project using SQL 2005 with a table that is...
Author: Kevin Cox SQL Server Date: 04/08/2008
Backup More Than 1GB per Second Using SQL2008 Backup Compression
Backup Compression in SQL2008 performs very well and it is easy to use. You could either use...
Author: lingzhuz Date: 03/02/2008
SSIS 2008 - world record ETL performance
Using SQL Server 2008 and SSIS 2008 the SQL Server Performance team working with Unisys and SQL CAT...
Author: Thomas Kejser Date: 02/29/2008
Now is time to try SQL 2008
SQL Server 2008 is just around the corner. SQLCAT has been working with our customers and partners...
Author: lingzhuz Date: 02/24/2008
SQLCAT Toolbox
SQLCAT members have published several tools on Codeplex and other places. They are all consolidated...
Author: Sanjay Mishra Date: 02/21/2008
Introducing SQLCAT.com
The SQL Customer Advisory Team has put the final touches on the site https://sqlcat.com/ which is our...
Author: Denny G Lee Date: 02/02/2008
New Partition Management Tool Available on Codeplex
As anyone working with partitioned tables knows by now, the process of creating stand-alone...
Author: Stuart Ozer MSFT Date: 01/28/2008