You are right, there is no built-in relational minus in SQL Server (SQL Server 2005 will have EXCEPT though). This code should do what you want:

SELECT *

FROM Table1

WHERE NOT EXISTS...

Duration simply shows the time it took from when a query started to when the results where returned. CPU shows the time the processor was busy executing the query. If...

SELECT Col1

FROM (SELECT A.Col1

FROM [Table1] A

UNION

SELECT B.Col1

FROM [Table2] B) foo

ORDER...

Actually i want to set the value of following constant

I assume you are talking about the dynamic property "NULL Collation Order" on the ADO connection object, and that you want...

First of all, without specifying an ORDER BY clause in your query you can never be sure of any specific order for the results.

Now, NULLs are treated as the lowest...

Unfortunately SQL Server does not implement unique constraints correctly as specified in the ANSI standard. Any entries in BOL that say "that a unique constraint will only enforce uniqueness for...

The space required will be a little more than the 500 kb original image. First you have a 16 byte pointer in the row where the image is logically contained....

Are you sure that you are installing Developer Edition and not Express Edition?

The 'report' of deadlock activity goes in the current SQL Server Errorlog. Regarding traceflags, see my article How to use trace flags in SQL Server 2000.

True, SPs are not compiled but they can and frequently do use a previously created execution plan. Inline code does not.

Not correct, ad-hoc SQL can very well reuse previously compiled...

If that is all it says that it is an extreme simplification, and not always correct.

Aha, I thought they were actually checking @@rowcount, but I guess they are just checking the properties of the recordset (or similar object).

Uhm, am I missing something here? As far as I can test, @@rowcount is not changed in the outside scope by actions done inside a trigger. Test script:

IF OBJECT_ID('dbo.foo') IS...

There is a known bug where the SQL Server perf counters are missing if Perfmon is running while SQL Server is restarted. Stop Perfmon and restart SQL Server, then start...

Here is one solution that does not use cursors, but since it calls a UDF it will suffer if there are many rows. Normally I would do this kind of...