Viewing 15 posts - 1,591 through 1,605 (of 3,348 total)
Steve Jones - SSC Editor (9/16/2013)
If someone has a good explanation that makes sense, I'm happy to change it.
The batch is processed in two phases.
Phase one is parsing. This works...
September 16, 2013 at 12:17 pm
Raghavendra Mudugal (9/12/2013)
Thomas Abraham (9/12/2013)
Raghavendra Mudugal (9/12/2013)
(I am on fire..... never got the 4 questions correct in a row before and this week...
September 12, 2013 at 12:06 pm
L' Eomot Inversé (9/11/2013)
Hugo Kornelis (9/11/2013)
Hany Helmy (9/11/2013)
Hope one of them will post a reply...
September 12, 2013 at 11:52 am
Hany Helmy (9/11/2013)
Hope one of them will post a reply explaining how he got the...
September 11, 2013 at 12:53 pm
david.gwalter (9/8/2013)
First time I have come across a question with an incorrect answer.A little disappointing for a novice like myself.
Look at it from the popsitive side - at least the...
September 9, 2013 at 12:43 am
The question is strange, and the answer is wrong.
"If an ELSE path is not provided in a CASE statement, the value it returns is NULL, not the initial value of...
September 7, 2013 at 5:05 pm
Jeff Moden (9/7/2013)
Good to "see" you again, ol' friend.
Same here! Still waiting for an opportunity to actually meet face to face and buy you the beverage of your choice. 😉
Let...
September 7, 2013 at 4:52 pm
Hi Jeff! 🙂
Jeff Moden (9/6/2013)
First and semantically speaking, using ROW_NUMBER() isn't the same as an actually Tally Table.
I completely agree with this....
Second, if you don't think the "physical" or "intrinsic"...
September 6, 2013 at 12:05 pm
I luckily never had to deal with silly interview questions. I have read about them, and I have thought about how to handle it if the situation comes up.
My most...
September 5, 2013 at 12:30 pm
L' Eomot Inversé (9/3/2013)
I haven't looked hard enough at column store indexes, but it is very hard to believe that an index that doesn't imply an order can imply clustering
I'm...
September 3, 2013 at 10:40 am
sknox (9/3/2013)
Hugo Kornelis (9/3/2013)
sknox (9/3/2013)
Wow.Nobody's mentioned what I consider to be the biggest problem with this question yet.
You must have overlooked the things already mentioned about ordering by Rune Irvin,...
September 3, 2013 at 10:37 am
L' Eomot Inversé (9/3/2013)
September 3, 2013 at 6:55 am
Rune Bivrin (9/3/2013)
Hugo Kornelis (9/3/2013)
sknox (9/3/2013)
Wow.Nobody's mentioned what I consider to be the biggest problem with this question yet.
You must have overlooked the things already mentioned about ordering by Rune...
September 3, 2013 at 6:48 am
sknox (9/3/2013)
Wow.Nobody's mentioned what I consider to be the biggest problem with this question yet.
You must have overlooked the things already mentioned about ordering by Rune Irvin, Terreador, and me.
September 3, 2013 at 6:20 am
John Mitchell-245523 (9/3/2013)
I'm on SQL Server 2008 R2 SP2. I ran both queries as a single batch, so there's a single execution plan, making it easy to compare them...
September 3, 2013 at 5:18 am
Viewing 15 posts - 1,591 through 1,605 (of 3,348 total)