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...
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...
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...
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...
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 ...
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...
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 ...
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...
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...
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 ...
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...