Thanks

I have a application, I want to know WHERE my users are waiting.

This will be done by a trace, and import to table..

There I want to run a statement showning...

Yes, but this only allows me to group on class / type of statement.

I would like to group simular statements

select * from table1 where id = 1 order by id

select...

Hey All

I have made a Server Side Trace, and have TRC file.

I need to load data, and group this data

template with group only groups on eventid.

If I have following statements

exec...

Hi thanks for the last advise,

Have one DB on 200+ GB and rest is small around 10-50GB, I have looked at partioning, but I'm hosted in a SAN and...

But in this case the best I can do 🙂

And then order a CLW on one DB at time..

Thanks for all the advises

Is this by making a reorganize instead? Or how?

Thanks for all the answers ...

I now know more on this topic, allways nice to learn new stuff

Hi

Using SS2005 ENT x64 SP3

My database is only 50GB and index takes 1min to rebuild, but it will crash app using it, and it is a 24x7 app where CLW...