ianstirk (4/6/2010)

---

Hi Jason,

I'm glad you liked the article.

There is an updated version of this script, without the deprecated objects, given in the book I am writing "SQL Server DMVs...

There does seem to be an obsession with points, but if a question is posted it should at least be "right".

There you go folks, I'd be glad to hear what useful info the log contains.

Cheers

Preet

06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process7862208

06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process5caf63e8

06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer id=process55a38118

06/21/2010 08:17:30,spid5s,Unknown,waiter event=e_waitPortOpen type=consumer...

RBarryYoung -

I like to feedback to those that were good enough to spend the time to assist. It certainly helps to see if the suggestions we make resolved the...

Spent some time investigating this (in test & live environments) and researching how execution plans are cached and what Parameter sniffing is, hence the delay.

The problem was as suggested,...

You are correct in both cases. Four massive frequently-returned result sets will hammer your network.

The only thing I can think of is that SSMS is also an app that is bound by the limitations of .NET and incurs its own overhead. I know there...

Thanks for the solution, tucankur.

As suleman writes it should be "bpa" not "bpn".

I didn't even get a link to MS website. It just reported "UpgradeAdvisor returned -1". I did...

Actually I think I might know why it doesn't work. Funny how writing (posting) the problem down makes it a bit clearer in your own mind.

I originally thought there were...

It is a real bug-bear how MS rely on users to do their debugging for them and as somebody pointed out, for free!

Actually, its at a cost to us...

Out of interest, what does sp_spaceused 'tablename' give you ?

spaceused returns number of rows in the table and is 11 char in len. (spaceused also depends upon internal stats being...

http://msdn.microsoft.com/en-us/library/ms178653(SQL.90).aspx

details what the impact of changing the compatibilty level would be. You need to examine your web apps to see if they will be affected by the changes...

If case insensitivity is your only criteria then "_CI_" is the key factor in the name of the collation you choose. If compatability is also a factor then you need...

Before shrinking you need to ask yourself why you are doing it ?

If your database has grown naturally then you will end up back where you started and worse (due...

Thanks Amit.

Useful tip as I have caught out by this one too.

sysjobschedules compatibility view does not return all of the fields that the system table in SQL 2000 has....