a dirty read has nothing to do with with an i/o completion wait, you're totally missing the point.

It's possible for a write wait on the tran log to cause...

as far as I know the columns are the same, think sp4 might have modified sysprocesses a little, your error is in the use of object_name() which doesn't take the...

So are the databases identical ? The SQL editions the same, the patch levels? same o/s etc. etc.

How about database and sevrer collations also identical?

Is this a proc or a...

io completion indicates a stall in your disk subsystem .. but I would only really expect to see an io completion wait on a write - not a read  .....

It does sort of make you wonder if discussions of non redgate tools will removed from the site. There can always be other sites!!

shared drives have to be added to the server resource groups which have the various nodes allocated etc.

check in cluster admin manager

Microsoft has pledged to only charge per socket, which is prob why sql2005 costs more! Note that if/when you move to virtualised environments the pricing gets a little more blurred...

Just to agree with SQLBill, no business buys another without an agenda, I've worked for companies who buy companies - believe me, they don't do it for the good of...

the table name prefix in front of the column name was created in a place I once worked, an example was a table called Monthly_Rates , the column names were...

sql 2k std can only support 2gb of ram regardless of the underlying o/s

The above extract seems to have come from an exchange site - still, on  a dedicated sql...

count the distinct values in the index row and compare to the rows in the table - if they match the index is highly selective, the bigger the difference the...

You need to understand how query plans exist in the cache and the process by which they operate. I find this quite often in my roles of performance tuning, the...

It's not that I'm cynical at all < grin > but I wonder what Redgate expect to gain from this move - and I wonder if this will mean a...

Sorry - just thought of a couple of worst others - inconsistent rmving of vwels from names or rmvngvwls alltgthr  + anything looking like txt speak +  spelling mistakes in...

I'm not a lover of non specific prefixes, such as t, tr or p. It makes the sorting more difficult. As a contractor I have to fit in with client's...