Tools similar to Quest SQL Tuning module.

Is anyone aware of third party tools that will analyze sql statements/script
s
and suggestion alternative methods of writing it similar to the Quest
product? I've found a few but they are not for MSSQL.

Charlie.

Hi Charlie,

I have searched in google.com and cannot find any third party tools on this
aspect neither. Let's wait to see whether other community could share their
experience here.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support
 ====================
 ====================
==============
PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
AM PST, February 14, 2006.  Please complete a re-registration process by
entering the secure code mmpng2006 when prompted. Once you have entered the
secure code mmpng2006, you will be able to update your profile and access
the partner newsgroups.
 ====================
 ====================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
 ====================
 ====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft support team using google.com? What will mgmt at Redmond say? Tsk
Tsk...  (just kidding) :-)

"Michael Cheng [MSFT]" wrote:

> Hi Charlie,
>
> I have searched in google.com and cannot find any third party tools on thi
s
> aspect neither. Let's wait to see whether other community could share thei
r
> experience here.
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>  ====================
 ====================
==============
> PLEASE NOTE the newsgroup SECURE CODE and PASSWORD will be updated at 9:00
> AM PST, February 14, 2006.  Please complete a re-registration process by
> entering the secure code mmpng2006 when prompted. Once you have entered th
e
> secure code mmpng2006, you will be able to update your profile and access
> the partner newsgroups.
>  ====================
 ====================
==============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>  ====================
 ====================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
>

Looks like Microsoft should work on a solution/tool since Quest is the
only player in the game apparently.

Charlie.

Bob  wrote:[color=darkred
]
> Microsoft support team using google.com? What will mgmt at Redmond say? Ts
k
> Tsk...  (just kidding) :-)
>
> "Michael Cheng [MSFT]" wrote:
> 

Looks like Microsoft should work on a solution/tool since Quest is the
only player in the market apparently.

Charlie.

Bob  wrote:[color=darkred
]
> Microsoft support team using google.com? What will mgmt at Redmond say? Ts
k
> Tsk...  (just kidding) :-)
>
> "Michael Cheng [MSFT]" wrote:
> 

Hi Charlie,

Quest's tool is the only one that I'm aware of.  (Quest is my employer,
btw.)  Symantec and Embarcadero have some performance tuning products, but I
don't think they include tuning recommendations for specific SQL statements
like Quest's SQL Tuning does.  Hope this helps,

-Kevin Kline
SQL Server MVP

"I support PASS - the Professional Association for SQL Server
(www.sqlpass.org)"

"Charlie" <SQL@newsgroups.nospam> wrote in message
news:4091DDBA-EBEF-4C6D-9445- C2A72D120E50@microso
ft.com...
> Is anyone aware of third party tools that will analyze sql
> statements/scripts
> and suggestion alternative methods of writing it similar to the Quest
> product? I've found a few but they are not for MSSQL.
>
> Charlie.
>