My Principal DBA here has just set me a rather interesting challenge.
"Can you get it to draw a rude picutre ?" He was referring to the Execution plan pane in Sql Server Management Studio. I confessed my skills were not that good but offered to ask some REAL experts. So here I am asking "Are you able to write some code that generates an execution plan diagram that is a picture of something ?" I think it may be prudent to leave out the 'rude' part so we do not offend anyone.Oh and incase you were wondering, we do have work to do here, honest!
asked Jun 09, 2011 at 08:33 AM in Default
How about a one sided christmas tree with sweary words in it? Just run the following, then when you are happy with the construction, uncomment the exec command:
You will always be constricted in the shapes you can construct because the query plan is pretty much always going to be a tree shape.
answered Jun 09, 2011 at 09:22 PM
I have seen drawings created with spatial data by Alex Whittles as SQLBits which was very interesting - http://www.purplefrogsystems.com/blog/2011/05/sql-server-art-using-spatial-data/
answered Jun 10, 2011 at 02:27 AM