T-SQL Code Optimizers

Question

Post reply

T-SQL Code Optimizers

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Jonathan AC Roberts SSCoach Points: 18361 More actions · Answer 1

Can you show use the before and after SQL so we can see how well it did?

rchantler SSCrazy Points: 2128 More actions · Answer 2

The 3rd party tool used was TOAD; neither freeware nor shareware but they do offer a free trial for 30 days.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

Toad has a Query Optimizer? Huh, I didn't know that...

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 4

rbarryyoung (11/11/2008)
Toad has a Query Optimizer? Huh, I didn't know that...

IIRC they purchased it from a company that developed it years ago. I tested the product out some way back when. VERY slick stuff even then!

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 5

They must've improved it a lot... I didn't like Toad because it kept croaking on me 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 6

Jeff Moden (11/11/2008)
They must've improved it a lot... I didn't like Toad because it kept croaking on me 😉

Heh. That's a neat bit of amphibology. 😀

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 7

*sigh*

This is actually a really clever self-referencing play on words, but it only works if you already know what Amphibology means, and hardly anyone does anymore. 🙁

(OK, I had to look it up the first time too! :Whistling: )

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 8

Heh... it wasn't wasted and is actually quite funny especially in reference to Toad... :PI just didn't get back to it and lost track of the thread.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)