A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2
In part 2, Paulo R. Pereira compares IN, EXISTS, SOME and JOIN plans, and shows again that the SQL Server Engine knows the best plan for a query.
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best
Subquery or join, IN or EXISTS? Four queries return the same result, and the execution plans show the SQL Server engine knows the best way to run them.
SQL SERVER – Convert IN to EXISTS – Performance Talk
A training attendee asked for a simple way to convert IN to EXISTS for better performance. Here is my example with the execution plans.
SQL SERVER – Disabled Index and Update Statistics
A reader asked how disabled indexes affect statistics. With the clustered index disabled, Update Statistics throws an error; see what happens once you enable it.
Estimated and Actual Execution Plans
Estimated and actual execution plans answer different questions; compare compiled choices with runtime rows, warnings, and resource use.
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
Snapshot Isolation has been in SQL Server since 2005, yet many shops still skip it. A simple example shows how it can reduce blocking transactions.