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