THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 44 (431 total posts) < 1 second(s)
  • Medians pre-SQL 2012

    SQL 2012 was a big release for working out the median in SQL Server, with the advent of the function PERCENTILE_CONT(). Its a very elegant way of working out the median (hint, thats the 0.5 point), even though its not actually an aggregate function, as Ive written before. Plus it doesnt even perform well. About a year ago, Aaron Bertrand ...
    Posted to Rob Farley (Weblog) by Rob Farley on January 26, 2015
  • re: MERGE gives better OUTPUT options

    Sorry Dipz, you don't have access to that information in an INSERT statement.
    Posted to Rob Farley (Weblog) by Rob Farley on January 14, 2015
  • APS / PDW Monitoring

    When you get a Analytics Platform System (APS) the appliance that hosts a copy SQL Server Parallel Data Warehouse Edition (EDW) and potentially a Hadoop cluster as well one of the things that you get is a Management Console. Its quite handy to be able to look at it and see if your appliance is healthy or not. The trouble with the Management ...
    Posted to Rob Farley (Weblog) by Rob Farley on January 12, 2015
  • Four SQL MVPs at LobsterPot – including three in Australia

    Today LobsterPot Solutions sets a new first. We are the only company to ever employ three current Australian SQL MVPs, giving us four awardees in total. Congratulations to Martin Cairney who joins Julie Koesmarno (AUS), Ted Krueger (USA) and me (AUS) as recipients of this prestigious award. This demonstrates LobsterPot's ongoing commitment to the ...
    Posted to Rob Farley (Weblog) by Rob Farley on January 1, 2015
  • re: Retrieving N rows per group

    Fixed now, Kevin. Thanks for pointing out my silly error.
    Posted to Rob Farley (Weblog) by Rob Farley on December 31, 2014
  • re: Retrieving N rows per group

    Yes - my focus on that last query was to demonstrate the impact of the residual predicate. I'll tweak the post at some point soon.
    Posted to Rob Farley (Weblog) by Rob Farley on December 31, 2014
  • re: Retrieving N rows per group

    Yes - the index I'm using there matches that.
    Posted to Rob Farley (Weblog) by Rob Farley on December 25, 2014
  • re: Retrieving N rows per group

    Hi Uri - Merry Christmas! Yes, your mileage can vary depending on various factors. However, you should still be wary of Sort operators, and it's good to be aware of the options. I generally prefer APPLY, but have been known to use both. Rob
    Posted to Rob Farley (Weblog) by Rob Farley on December 25, 2014
  • Merry Christmas

    I just wanted to take a moment to wish a Merry Christmas to you: people in the SQL Community; people I see at clients and the like; and especially those people I am incredibly privileged to have working at possibly the best SQL Consultancy in the world. To those who I have represent my brand: I love you guys! Youre all passionate about ...
    Posted to Rob Farley (Weblog) by Rob Farley on December 23, 2014
  • Retrieving N rows per group

    Sometimes a forum response should just be a blog post so heres something I wrote over at The question was somewhat staged I think, being from Paul White (@sql_kiwi), who definitely knows this stuff already. His question: I often need to select a number of rows from each group in a result set. For ...
    Posted to Rob Farley (Weblog) by Rob Farley on December 23, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement