Index Scans – Good or Bad? Lots of people ask about this question and I have built a blog post on the topic – SQL SERVER – Index Scans are Not Always Bad.
SQL SERVER – Index Scans are Not Always Bad
Are Index Scans Bad? The answer No. Index Scans are Not Always Bad. This was in-depth discussed with my client during the Health Check.
Optimize for Ad Hoc Workloads – SQL in Sixty Seconds #173
Today we are going to discuss if we should keep Optimize for Ad Hoc Workloads true or false. Let us see a detailed video about it.
Unlock SQL Login Without Changing the Password
Unlock SQL login accounts without a new password: switch CHECK_POLICY off and on. See the lockout, the fix, and what to do when MUST_CHANGE blocks it.
Avoid Join Hints – SQL in Sixty Seconds #172
Question: If they can change the join hints to improve the performance of the query. Well, the reality is that I always Avoid Join Hints.
Table Variables and Parallelism: Reads Yes, Inserts No
Table variables and parallelism: reads can run in parallel, inserts cannot. See the plan reason, the 1-row estimate at old levels, and when to use a temp table.
Group by Query Hash: Find One Query With Many Plans
Group by query hash to add up every cached copy of one query. See why the top query hides across entries in SQL Server.