Hi Gail,

Thanks for your reply. After doing some preliminary checks, I'm not seeing any real differences in the Time Stats. The only difference in the Execution Plans is...

Hey Russel - Thanks for replying, I thought for sure my post had been lost in the limbo of the interweb 😛

I'll have to try that. I have never...

I just happened to check my SQL Error Log this morning and have found a similar error; the only difference is that my device is being listed as a Virtual...

sweeeeeet.

exec sp_MSforeachtable 'select ''?'' as TableName, count(*) as TotalRows from ?'

The ? is in two single quotes, not one double quotes. '' not ".

[Chris runs off...

well this certainly gives me a lot to play with. I'm going to hopefully have a chance this aft to go through and try out these ideas; I'm very...

Hi Gail - Thanks for your reply - I actually have your article printed and in my Binder of SQL Stuff that sits on my desk; it's well-referenced, let me...

thanks Joeroshan for the quick reply. I now at least have a direction to go in. Have a great day and happy SQLing!

Chris

Hi Jeff - Thanks for the reply...the problem is that according to the agreement my company has with the development company, I cannot do certain activities and updating the stats...

...yup, that could work...my brain was going down a path and wasn't really thiniking about alternative ways to capture the data.

Hey all...

Just as an alternative, a friend of mine sent me this query. He's got a permanent table in his Master database to reference from, and now so do...

Awesome, thanks Lynn! I guess that makes sense if it's a specific error to your application or for more in-depth tuning purposes. Out of my scope of knowledge,...

Hey Vinay - I checked out BOL and when I try and run the query in my Query Analyser, I get "cannot find file c:\trace.trc". Any ideas what else...

Hey Vinay...thanks for the reply. I haven't checked BOL yet but wanted to answer your question...What I'm looking at is a trace file tracking errors and deadlocks etc. in...

Hey Gail! Thanks for replying...and as always, I have more questions (I continuously hope that by me being annoying and asking all these subsequent questions, someone one day will...

Awesome - thanks a lot Lynn, that's perfect!

Have a great day and may the Force be with you 😀

Chris