+1

But where is EXCEPT-1?

Why, if the qotd is identical to that of 2014/02/26, somebody got...

Curious: the winner is?

"EXISTS" with absolute less reads.

SET STATISTICS IO ON

GO

SELECT DISTINCT x AS 'EXISTS'

FROM A

WHERE exists(SELECT...

It's not equivalent, INTERSECT returns DISTINCT values.

SELECT DISTINCT X AS 'Intersecting'

FROM A

JOIN b ON b.y = a.x;

First time I see 99% OK.

😀

GO is NOT a statement, but a batch separator. It is recognized only by SSMS and you can change it. E.g. you can change with RUN_BABY.

This statement confirms it:

execute ('

SELECT...

Good question!

Thanks!

create database DEFAULT_DATABASE

This runs!

create database DELETE

This DOESN'T run!

You can use reserved words that stand for OPTIONS!

Thomas Abraham (2/19/2014)

---

Good question. Thanks Igor.

If you want numbers for your records in a SELECT, why not use:

ROW_NUMBER ( ) OVER ( <partition_by_clause> <order_by_clause> )

in...

Just one per year!

😉

+1

😛

Do Humor questions take 7 points?

Extremely easy.

😀

I also found this doc from MSDN that explains the answer

SSAS2005PerfGuide.doc

Easy one!

Thanks!

🙂

It is too much easy and logical!

😀

+1