THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Slow in the Application but Fast in SQL Server Management Studio - from Erland

Our MVP buddy Erland Sommarskog doesn't post articles that often but when he does, you should read them. His latest post is here:

http://www.sommarskog.se/query-plan-mysteries.html 

It talks about why a query might be slow when sent from an application but fast when you execute it in SSMS. But it covers way more than that. There is a great deal of good info on how queries are executed and query plans generated.

Highly recommended!

Published Tuesday, February 22, 2011 10:22 AM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

RichB said:

Wow,  what a great explanation.  Thanks for linking that!

February 22, 2011 7:47 AM
 

Chris Donges said:

Thank you, that was awesome.  Just saved my bacon.

March 16, 2011 9:26 PM
 

Adri Vinke said:

One of the best articles on SQL Server I have ever read.

Well researched and clearly explained.

November 16, 2011 8:27 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement