THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQLBits » sqlpass   (RSS)
  • New PASS Summit speakers that deserve votes

    I’m not going to ask you to vote for the abstracts that I submitted for the PASS Summit. I’m not even going to mention the abstracts that Roger and Ashley submitted. I figure if you’re reading this, you may have already read the post I wrote about them, back before SQLPASS had said that there’d be voting. Instead, I’m going to pick a few people ...
    Posted to Rob Farley (Weblog) by rob_farley on May 18, 2011
  • Using SQL Execution Plans to discover the Swedish alphabet

    SQL Server is quite remarkable in a bunch of ways. In this post, I’m using the way that the Query Optimizer handles LIKE to keep it SARGable, the Execution Plans that result, Collations, and PowerShell to come up with the Swedish alphabet. SARGability is the ability to seek for items in an index according to a particular set of criteria. If you ...
    Posted to Rob Farley (Weblog) by rob_farley on January 3, 2011
  • Visualising data a different way with Pivot collections

    Roger’s been doing a great job extending PivotViewer recently, and you can find the list of LobsterPot pivots at http://pivot.lobsterpot.com.au Many months back, the TED Talk that Gary Flake did about Pivot caught my imagination, and I did some research into it. At the time, most of what we did with Pivot was geared towards what we could do for ...
    Posted to Rob Farley (Weblog) by rob_farley on December 28, 2010
  • 24 Hours of PASS – sargability resources

    I just did a talk for 24 Hours of PASS on Sargability. I’ve done this talk before (about five months ago at the user group I run and at the PASS AppDev Virtual Chapter). There are a number of useful resources out there about sargability. I’ve blogged about it before, Brent Ozar has blogged about it, and so on. One thing that I don’t believe has ...
    Posted to Rob Farley (Weblog) by rob_farley on September 16, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement