Posted by Marc Melancon on 10/03/07 23:53

In "Microsoft SQL Server 2005 Waits and Queues" document you can find some
queries to find what index would be useful. It might not be exacly what you
seak but it will givie you other hints also.

MarcM

"Jack Vamvas" <DEL_TO_REPLY@del.com> wrote in message
news:N-qdnUSxU7DqvJ_anZ2dnUVZ8vSdnZ2d@bt.com...
> Do you mean listing all poor running queries? You could list all in
> Profiler
>
> --
>
> Jack Vamvas
> ___________________________________
> Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL
>
>
>
>
> "Cindy" <ckspot-temp@yahoo.com> wrote in message
> news:1191263723.914683.228640@r29g2000hsg.googlegroups.com...
>> At the risk of asking a stupid question -
>> Is anyone familiar with either a query against the systables or maybe
>> an outside tool that will provide a list of the most common joins that
>> have been made in user created views? I'm not talking about table
>> relationships that are established at the database level, but rather,
>> I'm referring to the ability to find which joins have been utilized in
>> poorly constructed databases where no relationships were established
>> in the first place.
>> Thanks in advance -
>> Cindy T.
>>
>
>

[Back to original message]