Graphical Query Plans

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » SQLServerCentral.com Announcements » Graphical Query Plans

Graphical Query Plans

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Tuesday, February 19, 2008 11:45 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item Graphical Query Plans

Post #457840

Kelsey Thornton

Posted Wednesday, February 20, 2008 1:17 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, March 04, 2013 4:10 AM
Points: 532, Visits: 281

See also
http://msdn2.microsoft.com/en-us/library/aa178423.aspx
(has some nice pretty pictures) :D

Kelsey Thornton
MBCS CITP

Post #457857

Key DBA

Posted Wednesday, February 20, 2008 6:42 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 26, 2009 3:02 PM
Points: 515, Visits: 655

I also found the same link, which also gives all of the Icons used in a Execution Plan for SQL Server 2000:

Optimizing Database Performance (SQL Server 2000)
Graphically Displaying the Execution Plan Using SQL Query Analyzer

http://msdn2.microsoft.com/en-us/library/aa178423(SQL.80).aspx

Here is the Icon reference for SQL Server 2005 Execution Plans:

SQL Server 2005 Books Online (September 2007)
Graphical Execution Plan Icons (SQL Server Management Studio)

http://technet.microsoft.com/en-us/library/ms175913.aspx

Happy T-SQLing

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

Post #457950

James Rochez

Posted Wednesday, February 20, 2008 9:23 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 9:07 PM
Points: 1,529, Visits: 824

For a little bit more information about what index statistics are and how they are used, you can try the following link:

http://technet.microsoft.com/en-us/library/ms190397.aspx

Post #458062

L' Eomot Inversé

Posted Tuesday, January 04, 2011 6:00 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 7,096, Visits: 7,156

A query specifically about SQL Server 2005 with a reference to http://msdn2.microsoft.com/en-us/library/ms178071(SQL.100).aspx in the explanation seems a bit strange, to say the least. That ".100" should be ".90".

Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1042769

« Prev Topic | Next Topic »

Permissions