Excellence in SQL Server

The default setting for the initial sizing of data and log files (and their autogrowth) is not adequate. I like to make sure that we set ...

We are currently migrating a large amount of SSIS packages (SQL Server 2008R2) to SQL Server 2016 at AWS. It has been a learning exercise...

By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose ...

Whilst deploying some reports to a new Sharepoint installation I noticed that the global ReportName variable (Globals!ReportName) include...

I was asked the other day was there any way to improve the performance of a large number of rows being inserted. My immediate thought was...

We had a query recently about a database that had a lot of objects starting with the name _dta_. We explained that these where hypothetic...

Whilst reviewing some code recently I saw the creation of a global temporary table (##). There was actually no need to create a global t...

The following is an example of a poorly named table from a major backup software vendor. This caused failures with the regular maintenan...

When SQL Server introduced the concept of included columns in indexes in SQL Server 2005, they didn't really provide any way to get infor...

We are currently working on a project to do a major data update on a manufacturing database to update client and product codes in prepara...

This is just a simple tip to improve the security of your SQL Server installation. If you can, you should try and rename the sa login. It...

A common occurrence in reviewing SQL Server implementations is finding very large databases that have log file sizes greater than the siz...

We see a lot of databases in full recovery that don't need to be. Why? Because the default for the model database (used as the template f...

How do you make sure that any user database created is created on the disks that you have set aside for the data, transaction log and bac...

The setting of the correct index fill factor is a constant source of debate amongst DBAs. There is a lot of information that you need to ...