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 » sql » collation   (RSS)
  • 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
  • My Lightning Talk in MP3 format

    Download it now via http://bit.ly/RFCollation  Lots of people tell me they wish they’d heard my Lightning Talk from the PASS Summit. This was the one that was five minutes, in which I explained Collation using examples comparing US English, UK English and Australian English. At the end, I showed my Arsenal thongs. You can see a picture of ...
    Posted to Rob Farley (Weblog) by rob_farley on December 23, 2010
  • Collation errors in business

    At the PASS Summit last month, I did a set (Lightning Talk) about collation, and in particular, the difference between the “English” spoken by people from the US, Australia and the UK. One of the examples I gave was that in the US drivers might stop for gas, whereas in Australia, they just open the window a little. This is what’s known as a ...
    Posted to Rob Farley (Weblog) by rob_farley on December 13, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement