Viewing 15 posts - 76 through 90 (of 848 total)
I was just reading about upgrades to 2014 yesterday. Apparently the cardinality estimator changed for SQL 2014 and that can cause some queries to have degraded performance compared to how...
June 11, 2015 at 11:09 am
Looks like I should have just closed out the window instead of trying to answer this one since there was obviously something missing from the script. I imagine we will...
June 10, 2015 at 9:59 am
I got B and then A using 2012 (Microsoft SQL Server 2012 - 11.0.5548.0 (X64)). I would have expected version B for both as well though. Odd behavior.
June 4, 2015 at 11:24 am
Nice question Steve. I always look for alternatives to cursors but we do still have a few running. I replaced one recently with the lead and lag functions in SQL...
May 22, 2015 at 8:38 am
I recalled this subquery behavior from another question a year back or more. Thankfully I have never seen any unaliased column references like this in production! Thanks for the question.
May 20, 2015 at 9:25 am
I've never used this format so I learned something new. Thanks Steve.
May 12, 2015 at 2:38 pm
Nice question Kathi. This is a much simpler method to do this than what I have used before.
April 27, 2015 at 11:26 am
Nice question and thanks for the further explanation Hugo!
April 17, 2015 at 9:38 am
Luckily there was only one correct answer so I didn't have to play the "guess the author's intention" game. 😛 LEAD and LAG have been very helpful in simplifying some...
April 15, 2015 at 11:56 am
Nice question. Hopefully I won't have to use it but it is definitely good to know about!
April 13, 2015 at 11:14 am
I kept looking for a catch but it turned out this was just an easy question. 🙂 Thanks Steve!
April 8, 2015 at 11:27 pm
Nice question. I've never tried an unattended install. Good to know!
April 2, 2015 at 11:08 am
Viewing 15 posts - 76 through 90 (of 848 total)