TRUNCATE TABLE master..sysdatabases

...and other neat SQL Server tricks
posts - 55, comments - 60, trackbacks - 14

SQL Server Execution Plan Icons

Here's a handy link that shows all the query operator icons used in graphical SQL Server execution plans.

Your mission, if you choose to accept it, is to write a query or batch that displays all of them. :)

This tape/disk/database will self-destruct in 5 seconds.  Good luck, Jim.

Print | posted on Thursday, August 26, 2010 2:42 PM | Filed Under [ Coolness ]



# but there's this one thing...

Sounds like a great challenge. And to guage how difficult it was going to be, I clicked on one of the icons I was unfamiliar with... The first one as it turns out: The Arithmetic Expression ShowPlan Operator.

According to the docs, that Arithmetic showplan operator is not used in SQL Server 2008 R2, 2008 or 2005. :-(

So I'm going to take a crack at another challenge: Hack together a .sqlplan file that is valid enough that SSMS shows as many of the icons as possible.
8/27/2010 2:37 PM | Michael J Swart

# re: SQL Server Execution Plan Icons

I noticed that too, right after I posted of course. I wonder why it's included if it's not used; it's probably a strictly internal sub-operation of other operators. Wonder if there's a trace flag that would display it.
8/30/2010 12:04 PM | Rob Volk
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET