Continue creating QotD. It was a good start!

It is a nice question for beginners: If one with "below than average expertise" tried out his first QotD this question surely was...

Nice idea to write such a book!

I would have appreciated if you hadn't written everything in bold letters and instead had given a compressed overview about the content, as well...

Also nice piece of information regarding INTERSECT and EXCEPT: NULL values are regarded as the same. A behaviour as if SET ANSI_NULLS were OFF.

While DELETE is a pure DML statement which has no side effects on an IDENTITY, TRUNCATE resets the IDENTITY and needs ALTER TABLE permission, which appearently means that the...

In my opinion your questions were tough: You did a very good job! Better than the most questions for politicians in talk shows (that won't answer the questions anyway).

Best regards

Jens-Peter...

Hi, Tom,

can you imagine my joy when I first thought to have found another worshipper of Vogon poetry? And my disappointment when I realized that this was no Vogon, but...

L' Eomot Inversé (9/27/2013)

---

Yes.

But England is full of ignorant pedants who will claim it is not grammatical, because they insist that the past participle of get is not...

logitestus (9/27/2013)

---

:blush: umm, what should you do when you can't perform simple math in your head? This was a pretty simple question (since I have been dealing with...

Steve, thank you for your work and for this interview: You spend a lot of time doing good things good!

When reading this interview I had the feeling to read the...

What I found even more interesting:

"The standard varbinary(max) limitation of 2-GB file sizes does not apply to BLOBs that are stored in the file system."

The file size is then, as...

Was just curious about the behaviour of CTEs with JOINed tables: I expected same behaviour as of views.

IF OBJECT_ID('temp_test_FK') IS NOT NULL

DROP TABLE temp_test_FK;

IF OBJECT_ID('temp_test') IS NOT NULL

DROP TABLE...

Carlos,

sure, you may be right.

And the topic of this QotD is CTE and the usage of DML.

With the example for identifying duplicate records I wouldn't agree to CTEs being...

KWymore (9/9/2013)

---

Miles Neale (9/9/2013)

---

Ross.M (9/9/2013)

---

I was just about to say, don't know what everyone is talking about,...

Same for me, anyway...

Hoi, Samith,

how fits the explanation of your reference to our problem at hand?

The reference explains something about the parser of SSMS before the execution of the code and the block...