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 (437 total posts) < 1 second(s)
  • re: Why isn’t my filtered index being used?

    Hi Marcel, Yes (as per my post that I linked to above), but if you use parameters (with OPTION (RECOMPILE)) then the QO needs to come up with a plan that is general and is unlikely to use your filtered index.
    Posted to Rob Farley (Weblog) by Rob Farley on February 24, 2015
  • re: Minimising Data Movement in PDW Using Query Optimisation Techniques

    Hi Davos, It's the Query Optimizer that rewrites the queries. In the example where you can't see the 'Unknown' tables, it's because there has been data movement, and that data is stored in the tempdb tables. I'm saying the view is a good thing. It forces the extra predicates to be used, which contradict with each other on the joins that would ...
    Posted to Rob Farley (Weblog) by Rob Farley on February 23, 2015
  • Why isn’t my filtered index being used?

    Quite often, people have filtered indexes but find theyre not being used as often as theyd like. I was reminded of this recently when I read a good post by Kendra Little from about filtered indexes. In it, Kendra talks about how the WHERE clause of a filtered index allows an IN clause, but not an OR clause (to quote someone from ...
    Posted to Rob Farley (Weblog) by Rob Farley on February 22, 2015
  • re: SQL Injection – the golden rule

    Ah yes. Thanks Rich. :)
    Posted to Rob Farley (Weblog) by Rob Farley on February 20, 2015
  • SQL Injection – the golden rule

    The problem with SQL Injection is that most people dont realise the fundamental concept which makes SQL Injection vulnerability not only easy to spot, but also easy to prevent. And its the thing that SQL Injection has in common with countless other hacking mechanisms that have been around since the early days of computing. The simple truth is ...
    Posted to Rob Farley (Weblog) by Rob Farley on February 9, 2015
  • re: Medians pre-SQL 2012

    Thank you Joe - terrific fun to read this.
    Posted to Rob Farley (Weblog) by Rob Farley on February 1, 2015
  • 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement