Microsoft SQL Server

Microsoft SQL Server DBA Setup Checklist and Recommendations

Install SQL Server Service Packs and Cumulative updates recommended from http://sqlserverupdates.com http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/ http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-2-after-the-install/ Keep Long Term Backups at least 1 year (in case of uncaught database corruption) Make sure backups are stored in 3 different physical locations (at least 3 different…

Partition Alignment for SQL Server or Exchange

How to check partition alignment quickly is below. File allocation size and the partition offset have to both be correct for any performance gain.  If one of these are incorrect then you can increase your disk performance by fixing the…

SQL Server Integration Services Resources

31 Days of SSIS http://www.jasonstrate.com/2011/01/31-days-of-ssis-the-introduction/ SSIS Tutorial: Creating a Simple ETL Package http://technet.microsoft.com/en-us/library/ms169917.aspx We Loaded 1TB in 30 Minutes with SSIS, and So Can You http://msdn.microsoft.com/en-us/library/dd537533(SQL.100).aspx SSIS Tutorial http://www.accelebrate.com/library/tutorials/ssis-2008 MSDN SSIS Video Tutorials http://msdn.microsoft.com/en-us/library/dd299421.aspx SSIS Virtual Lab http://blogs.technet.com/b/jweston/archive/2012/02/29/sql-2012-new-msdn-virtual-labs.aspx

T-SQL to Change Fill Factor For All Indexes in a Database

I recently needed to change the fill factor for an entire database.  The database used uniqueidentifiers as primary keys for most of the tables. USE [YourDbName] GO — Show Fragmentation sample on YourTable Index. SELECT avg_fragmentation_in_percent, avg_fragment_size_in_pages, fragment_count, avg_page_space_used_in_percent FROM…

%d bloggers like this: