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 Technical Reference Guide. A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote plan sufficiently for the upgrade, and match the complexity of your database application. Otherwise,… Read more

SQL Server 2008 Analysis Services Performance Guide now available

Thomas Kejser and I made some significant updates to the SQL Server Analysis Services Performance Guide for SQL Server 2008 – it’s available here. Our hope is to keep it alive and make updates as necessary. So if there is something you’d like to see added or have any comments at all, shoot me a note at richtk@microsoft.com…. Read more

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 SQL Server 2008.  It is not intended to be an in-depth tutorial on how to implement it.  Instead, it will concentrate on best practices.  The basics of how the new full text search feature works is found… Read more

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 concurrent users Siebel CRM 8.0 benchmark on SQL Server 2008 (http://www.microsoft.com/isv/oracle/). The benchmark demonstrated that the combination of Microsoft Windows Server 2008, SQL Server 2008, Siebel CRM Release 8.0 architecture and HP BL460c/BL680c Servers is a powerful and cost… Read more

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 a consolidated PDF form at SQLCAT’s Guide to BI and Analytics] Check out the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series:… Read more

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 Lists, Technical Notes, Whitepapers, and Toolbox.  As well, now our blogs our mirrored to sqlcat.com for easy access to all SQLCAT tips, best practices, and lessons learned. Right now, you can see our graphic noting… Read more

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 variable instead of temp table, it makes the stored procedure code look more tidy. The puzzling part is the same stored procedure now running a lot slower. The estimated plans looked the same using temp table… Read more

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: http://blogs.msdn.com/sqlcat/archive/2008/09/18/scaling-heavy-network-traffic-with-windows.aspx), Thomas and I (with the help of many others) have created a “Top 10 list” of the best practices for SSIS that can be found on sqlcat.com: Top 10 SQL Server Integration Services Best Practices As… Read more

Project Gemini – building models and analysing data from Excel

Saw an amazing BI demo this morning at the BI Conference here in Seattle. Donald Farmer showed how over 20M rows of data can be modeled and analyzed in memory. To build a model today, a DBA needs to define dimensions and fact tables, get the relationships right, define calculations, deploy it to a server, build… Read more

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 Microsoft’s backyard).  See http://summit2008.sqlpass.org/ for all the details.  This SQL PASS will be very special.  The SQL Server engineering team is sending up to 300 developers to the conference.  You won’t have to walk very far in order to run… Read more