Tag Archives: code language

  1. Collation: Correction -> Instance

    Leave a comment

    April 14, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading about them. As I read …
    Continue reading

  2. Collation: Correction -> Expression, Column, Database

    Leave a comment

    April 10, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading about them. As I read …
    Continue reading

  3. T-SQL Tuesday #53: Why so serious

    4

    April 8, 2014 by Kenneth Fisher

    Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. …
    Continue reading

  4. Default nullability of a new column

    Leave a comment

    March 31, 2014 by Kenneth Fisher

    Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? …
    Continue reading

  5. Collation: Expression

    Leave a comment

    March 26, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading. As I read I started …
    Continue reading

  6. Collation: Location

    Leave a comment

    March 24, 2014 by Kenneth Fisher

    I started reading about collations after I had a recent run in with them. As I read I started to …
    Continue reading

  7. Collation: Definition

    2

    March 19, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading. As I read I started …
    Continue reading

  8. Characters you should never ever use in an object or schema name!

    Leave a comment

    March 5, 2014 by Kenneth Fisher

    You can put pretty much any character you want into an object or schema name by enclosing the name in …
    Continue reading

  9. Impersonating a server level permission

    2

    February 26, 2014 by Kenneth Fisher

    Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s …
    Continue reading

  10. What’s the difference between a temp table and a table variable?

    2

    February 24, 2014 by Kenneth Fisher

    I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 163 other followers