Reputation
203
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 16
Newest
 Yearling
Impact
~13k people reached

  • 0 posts edited
  • 0 helpful flags
  • 66 votes cast
May
20
comment Group by minute and two minute intervals
Thanks for the heads up regarding GO <int> - I didn't even know that was an option for GO. I'll add it to the list of enhancements for SQL Fiddle (my site).
Mar
22
comment Oracle build_plan_xml visualizer
Thanks for your answer, phil. Text would suffice if there were no convenient graphical alternatives, but as you can see now I've got the Oracle flash-based execution plan viewer working. I think this format is preferable for my specific case. Your tips would certainly be useful for people looking to solve similar problems, however.
Mar
22
comment Oracle build_plan_xml visualizer
Sigh, gotta love Oracle. It works when you go to bed and breaks by the time you wake up.... Anyhow, it's working now. Hopefully it will continue to do so.
Mar
22
comment Oracle build_plan_xml visualizer
Thanks for your tip! I've updated the site to use the flash viewer behind the "ACTIVE" option (Check out this link to see it in action: sqlfiddle.com/#!4/ee7da/596). Had to do some serious mucking around with Oracle's HTML and JS to get it to work, but finally managed to do so. Thanks!
Mar
21
awarded  Benefactor
Mar
21
accepted Oracle build_plan_xml visualizer
Mar
20
revised Oracle build_plan_xml visualizer
added 294 characters in body
Mar
15
awarded  Promoter
Mar
13
comment Oracle build_plan_xml visualizer
@a_horse_with_no_name thanks I'll definitely look at that.
Mar
12
asked Oracle build_plan_xml visualizer
Mar
12
comment Interpreting SQL Server's Showplan XML
Justin - I cannot sing your praises high enough! Your code was super easy to integrate (a match made in heaven!), and just amazing results (as you can see). It's pretty rare that there is something out there that really is the perfect solution to a problem, but this was. Thanks so much!
Mar
12
accepted Interpreting SQL Server's Showplan XML
Mar
11
revised Interpreting SQL Server's Showplan XML
added 574 characters in body
Mar
9
comment Interpreting SQL Server's Showplan XML
@JNK - I've thought about that, but according to the MS docs (msdn.microsoft.com/en-us/library/ms180765.aspx) that option is deprecated. I figured I should go with the most preferred option. I suspected (and now see confirmed) that the XML option would afford more flexibility via manipulation, as well.
Mar
9
comment Interpreting SQL Server's Showplan XML
Wow @MartinSmith that's exactly what I'm after. Thanks a lot! If you want to put that down as an answer, I'll happily upvote and accept.
Mar
9
awarded  Commentator
Mar
9
comment Interpreting SQL Server's Showplan XML
@MartinSmith - by "seen one" do you mean seen a visual representation of the showplan xml? If so, see my update.
Mar
9
revised Interpreting SQL Server's Showplan XML
New option
Mar
9
asked Interpreting SQL Server's Showplan XML
Feb
8
awarded  Student