@Solomon Rutzky:
thanks for working this out, my tests had shown similar results; I simply wondered what it would be like in this particular tests as it "fits" the subject.

Interesting article. 
As a side note, if I remember correctly, MSSQL will 'ignore' out-of-page data (LOB_DATA) when it comes to PAGE compression; I guess COMPRESS() and DECOMPRESS() are the 'workarounds'...

Hi there,
thank you for the article, I really enjoyed reading it and following the thought-process and as such feel kind of bad for criticizing on it but...
......

It gets worse and worse: on my case-sensitive server SELECT * FROM information_schema.ROUTINES doesn't even work!

(I only picked it because I had to pick 2 but it still felt like...

Solomon Rutzky (1/19/2016)

---

deroby (1/18/2016)

---

However, since one can't use UDDT's on temporary tables (the UDDT sits in the current db, not in the tempdb) there is no way to do

CREATE...

The solution we use is actually to never create #temp tables that way. Ever.

In fact, there are multiple reasons not to.

1. The collation issue as explained in the article

2. Changing...

Interesting and I admit I hadn't thought the whole indexing thing that far through yet (**), but it sure makes sense.

So, in a way this means there is no such...

I'm going to chime in on the 'Yay for sp_helptext' team.

The stored procedure might be old (and indeed in need for some TLC, thumbs up for the article!),...

Under the hood, CTE is pretty much identical to using sub-queries; only the syntax is different: the actual query...

@kenneth Fisher: Thx for the article, it's most certainly something that gets a lot of people confused and the given examples are a great help to show what's...

arnipetursson (11/12/2013)

---

When I run the two queries (outer join vs NOT EXISTS),

the outer join query runs in 4-9ms (69 logical IO n the temp tables and 0 scans and...

I'm starting to feel bad here ...

Patrick Cahill (11/12/2013)

---

I agree that using WHERE NOT EXISTS is easier to read, the purpose of the article was to show how to...

Hi there,

Thx for the article about what often turns out to be a brain-breaker for a lot of people starting out with SQL.. but... (there's always a but =)

Although the...

Hmm.. Although I...