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 » t-sql tuesday » collation   (RSS)
  • How to make text searching go faster

    ...but first, let’s look at one oft-forgotten reason why finding a particular piece of text can be slow, if not impossible: collation. This will then provide a useful platform for making it go faster. I say ‘impossible’, but of course it’s never impossible to find something in a database (assuming it’s there). It might take longer, but you can ...
    Posted to Rob Farley (Weblog) by rob_farley on March 7, 2016
  • Check the settings when installing SQL Server

    Next, next, next, next, next... you know the drill. Except that when installing SQL, it’s simply not good enough. The defaults might not work for you, and that makes this post qualify for this month’s T-SQL Tuesday, hosted by Andy Yun (@sqlbek). Most things are fine, but there is one page which you really shouldn’t ignore. And it’s not even ...
    Posted to Rob Farley (Weblog) by rob_farley on July 13, 2015
  • 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
  Privacy Statement