|
Posted by Jack Vamvas on 10/02/07 10:46
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.
>
Navigation:
[Reply to this message]
|