Search
Repost - originally posted 19-07-2012
- Sep 12, 2017
- 1 min
Autoclose and autoshrink - set them to off
By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose ...
3 views0 comments
Repost - originally posted 05-07-2012
- Sep 6, 2017
- 1 min
Insert query performance improvement
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...
2 views0 comments
Repost - originally posted 29-06-2012
- Sep 4, 2017
- 1 min
SQL Server Clustering
Recently we were asked to build a SQL Server cluster. My initial thought was to use some other technology to provide high availability li...
5 views0 comments
Repost - originally posted 24-10-2012
- Jul 27, 2017
- 1 min
Implicit conversions and poor performance
Whilst debugging a slow query recently and went through the usual suspects. There were indexes on join columns, all the table joins were ...
7 views0 comments