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 13-07-2012
- Sep 8, 2017
- 1 min
Report name variable in Sharepoint
Whilst deploying some reports to a new Sharepoint installation I noticed that the global ReportName variable (Globals!ReportName) include...
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 26-06-2012
- Sep 1, 2017
- 1 min
Hypothetical indexes
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...
2 views0 comments
Repost - originally posted 14-06-2012
- Aug 27, 2017
- 1 min
Local and Global Temporary Tables
Whilst reviewing some code recently I saw the creation of a global temporary table (##). There was actually no need to create a global t...
3 views0 comments
Repost - originally posted 1-06-2012
- Aug 22, 2017
- 1 min
Poor object naming
The following is an example of a poorly named table from a major backup software vendor. This caused failures with the regular maintenan...
3 views0 comments
Repost - originally posted 22-05-2012
- Aug 20, 2017
- 1 min
sp_helpindex stored procedure improvements
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...
12 views0 comments
Repost - originally posted 20-05-2012
- Aug 17, 2017
- 1 min
Changing the sa login for improved security
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...
4 views0 comments
Repost - originally posted 21-06-2012
- Aug 14, 2017
- 1 min
Full recovery = transaction log backups
A common occurrence in reviewing SQL Server implementations is finding very large databases that have log file sizes greater than the siz...
5 views0 comments
Repost - originally posted 29-05-2012
- Aug 13, 2017
- 1 min
Model database recovery setting
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...
5 views0 comments
Repost - originally posted 28-11-2012
- Aug 12, 2017
- 1 min
SQL Server configuration - default file locations
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...
3 views0 comments
Repost - originally posted 04-12-2012
- Aug 11, 2017
- 1 min
SQL Server configuration - default fill factor
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 ...
3 views0 comments