Viewing 15 posts - 1 through 15 (of 23 total)
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'...
October 1, 2018 at 6:07 am
November 6, 2017 at 10:04 am
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...
......
November 6, 2017 at 3:42 am
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...
January 25, 2016 at 4:29 am
Solomon Rutzky (1/19/2016)
deroby (1/18/2016)
CREATE...
January 19, 2016 at 3:33 pm
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...
January 18, 2016 at 3:19 am
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...
January 15, 2016 at 1:36 am
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!),...
June 18, 2015 at 3:33 pm
alex pilsworth (1/26/2015)
Common table expressions provide a neat way of doing this...
Under the hood, CTE is pretty much identical to using sub-queries; only the syntax is different: the actual query...
January 26, 2015 at 3:32 am
@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...
January 17, 2014 at 8:07 am
arnipetursson (11/12/2013)
the outer join query runs in 4-9ms (69 logical IO n the temp tables and 0 scans and...
November 13, 2013 at 6:45 am
I'm starting to feel bad here ...
Patrick Cahill (11/12/2013)
November 12, 2013 at 1:43 pm
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...
November 12, 2013 at 3:23 am
L' Eomot Inversé (11/3/2013)
You are making a big mistake if you think that the existing numeric aggregates deliver results which are independent of evaluation order. because they don't.
Hmm.. Although I...
November 3, 2013 at 2:05 pm
Viewing 15 posts - 1 through 15 (of 23 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy