It does use lots of procedures but they all start with proc_

Most of the application is .Net code and compiled dll's that I don't see. Some of the profiler text...

I tried usp_who5 It does gives me more information but not what I am looking for.

The applications login default database is correct and using SQL Profiler I can confirm that...

Thank You so much for this article.

It indirectly solved a long standing performance problem I have with a third party application.

There are 2 queries with useless Where clauses with likes...

In the Indexing best practices

Here is another avoid

Avoid using fields in indexes that are updated frequently.

Status fields are a prime example. Each time the field is updated the index has...

Ok I figgured this out myself.

I went with correct language and did a few replace() statements. so SINGLE_BLOB into an XML field.

I noticed all html formating had an extra &...

I was quite certain the issue had nothing to do with the network crash but it did happen during our analysis...

After the crash somehow we had lost the order by...

How many duplicates do you have?

This might do it for you. set @rcnt toi the number of duplicates.

I know this is a cursor. But I do come from the oracle...

I believe the primary key is redundant in those indexes.

If you were to join tables using this primary key with a where clause using the lastname I would expect the...

The primary key field should never be used as the first field of another index.

For this index to be used you will have to supply the primary key field and...

If you do find good info in the XML dump please share it!

And my earlier post should have been 311 Million records were duplicated.

The first things I would look for is buffercache hit rates and physical I/O.

I all tables are being used and with a block size of 8k and 1 million tables...

Yes there is a top SQL screen.

You can view and sort by almost any parameter you wish. CPU time, Physical reads, Elapsed time, logical Reads etc.

When I am tunning I...

I am using Quest Spotlight for SQL Server.

I also use Quest Spotlight for Oracle.

I love the graphics I can quickly see green is good and the closer we get to...

Awesome guys

Thank you!

I tend to come at this issue from a different angle.

I agree with the others on this post that "it depends".

But there are ways you can determine some of the...