Tag Archives: Performance

SQL Server data warehouse performance settings

This is the checklist you need to ensure your SQL Server environment is optimally setup for Data Warehouse loads. I have compiled it based on experience and the FastTrack data warehouse reference architecture. Confirm that Windows Server 2012 Application Server … Continue reading

Posted in SQL Server 2012, SQL Server 2014 | Tagged , , , | Leave a comment

Partition Switching for Large Data Loads

This is the first in a four-part series of blog posts explaining my journey using SQL Server’s partition switching functionality to load a very large Fact tables. Partition switching is a Microsoft best practice data loading technique as described in … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014 | Tagged , , , , , | 2 Comments

Recommended Maxdop for SQL Server

There are some server level settings in SQL Server that you want to, and must, change. Each installation and client environment is different. Hence you want to get the best performance from you SQL that you can based on your … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014 | Tagged , | Leave a comment

Who is active on SQL Server?

SQL, what are you doing? Most database developers and administrators will have this question some point in time, especially when your program takes “forever” to return results. Thanks to Adam Machanic’s wonderful Stored Procedure (SP) “sp_whoisactive“ found here, you will … Continue reading

Posted in SQL Server 2014 | Tagged | Leave a comment

Top 10 SSIS Performance Best Practices

The SQL CAT team has loads of experience in loading large volumes of data using SQL Server Integration Services. Thanks to the team for putting this wonderful post together. Here are highlights plus some of my own tips: Do all … Continue reading

Posted in SQL Server 2014 | Tagged , , | Leave a comment

SQL 2008 ETL Performance Rocks

Here is a very interesting site from the SQL Team on their World Record ETL Performance loading 1.18 TB in under 30 minutes.

Posted in SQL Server 2008 | Tagged , , | Leave a comment