I only have SQL Server 2005 to test with here, but I am getting the same results as Cris. The cost for the first and third queries are each 36%...

The error message is saying that there were no unused (unassigned) open objects available when one was needed, so an inactive (but assigned) had to be used for the new...

SQL Server 2005 introduces the concept of allocation units for data storage. Each partition (tables and indexes now consist of one or more partitions) has up to three allocation units...

Hey Shawn, I don't think any time was wasted. It is always nice with a good debate that really has people getting down into the internals of SQL Server to...

I can only confirm the problem with SQL Server 2005 April CTP English Developer X64 Edition, running on Windows XP 64-bit. I would recommend you to register a bug a...

If it started occuring because you changed an option then I do not have any idea about the possible causes for it. But there are several issues listed at Microsoft...

Like Rob says, if you always require one row to be indicated, then you would need to have some method of selecting which new row should be indicated when the...

What isolation level is it running in?

Here is an example to deadlock a reading-only process.

-- Run this in first query anylyzer window:

BEGIN TRAN

UPDATE sometable SET something = whatever

-- Now open...

If you could produce a small repro then it would be easier to figure out what is going on. In fact, I think that while producing a repro I would...

No, actually it would allow one row with the value 1 in the uniqifier column, and nothing else. No more rows, and nothing else than a 1 in uniqifier.

The original...

SQL Server 2005 Beta 2 does not play really nice with SQL Server 2000. However, the latest release, April CTP (June CTP should be out any day I hope), is...

It's in milliseconds, and it only shows the accumulated CPU for a SPID when SET STATISTICS TIME is ON for queries executed on that spid.

Something like:

SELECT CASE

WHEN EXISTS

(SELECT *

FROM Rooms

WHERE Event_Type = 'aa'

AND name LIKE '%Cinema 1%')

THEN 'b'

Have you tried allowing cross-database ownership chaining for the entire server? Not that it should do any difference, since you have it activated for the databases in question already.

I am not sure whether this is the best way or not. It was just an alternative that popped up in my head when I read the question. The nice...