SQL Server – Slow Finish

Posted on Updated on


As part of optimizing your SQL queries, if you want to line of code to include the execution plan, drag this instruction before execution.

SET STATISTICS SHOWPLAN_XML ON

If you want to optimize the recovery of your data in an environment with a default isolation level of Read Committed or SERIALIZBLE, slide this instruction before execution.

SET TRANSACTION ISOLATION LEVEL SNAPSHOT

As part of query optimization, you can associate a clean SQL query execution plan for you so to override the behavior of the query optimizer, see reference Plan in SQL Server Management Studio, you can create your SEEK FORCE clauses on your favorite index etc.

link : https://technet.microsoft.com/fr-fr/library/bb895390(v=sql.105).aspx

You can sometimes just be an update statistics 🙂

For the database novice, the positioning of the index is very important and is based on real data collecting tools (Production Environment)

As for the SQL Server after try: Database Engine Tuning Advisor, included in SSMS since the 2012 version.

GC.Collect

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s