Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Graphical Query Plans Expand / Collapse
Author
Message
Posted Tuesday, February 19, 2008 11:45 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Graphical Query Plans
Post #457840
Posted Wednesday, February 20, 2008 1:17 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:16 AM
Points: 534, Visits: 282
See also
http://msdn2.microsoft.com/en-us/library/aa178423.aspx
(has some nice pretty pictures) :D


Kelsey Thornton
MBCS CITP
Post #457857
Posted Wednesday, February 20, 2008 6:42 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr 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
Posted Wednesday, February 20, 2008 9:23 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

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
Posted Tuesday, January 4, 2011 6:00 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 8,551, Visits: 9,043
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
Post #1042769
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse