Cost Threshold For Parallelism – Best Practice and Recommendations
Most DBA’s will make sure they are across the Maximum Degree of Parallelism setting in SQL Server. A setting often ignored though is Cost Threshold for Pa...
Category: Performance
SQL Server Update Statistics – Quick Tips & Examples
An important part of obtaining sizzling database performance is ensuring statistics are up to date. Statistics that are up to date will ensure that queries will...
SQL Server Plan Guide – How To Create One – And Why You Would Want To!
I have to be honest with you, until I began studying for exam 70-461 (Querying Microsoft SQL Server 2012) I had little to do with SQL Server Plan Guides. It bec...
Information to gather when troubleshooting performance of a query from a remote location
This assumes you already know the basic layout/ SQL version of the remote location Exact details of issue (e.g 9 times out of ten it takes more than 30 seconds ...
Most useful DMV’s SQL Server
Its good to have a toolbox of useful DMV’s at hand for when a problem arises. Here are some of our most useful DMV’s that we end up using on a daily...
How To Identify Duplicate Indexes in SQL Server
Duplicate indexes can slow things down on a database. There is no need for them, so if you identify any get rid of them. T-SQL Script that identifies duplicate ...
Implicit conversion causing index scan
If when you are looking at a query plan and you see it doing an index scan along with an implicit conversion then the chances are that if you fix the implicit c...
How to rebuild all the indexes on a single table – SQL Server
If you have ever wanted to rebuild all the indexes on a table its pretty simple. I have had to do this sometimes when troubleshooting a situation and not wantin...
How to know whether to rebuild or reorganize indexes plus a simple T-SQL only index rebuild script
Simple query to show logical defragmentation You may find after a rebuild/reorg that some of the fragmentation values are the same or dont change much. However ...
How to identify your top ten table “hotspots” – SQL Server
Have you ever been asked to identify the most accessed and utilized tables in your database and wondered if there was a quick way to do it? This script which we...