Category Archives: T-SQL

  1. Collation: Confusion

    Leave a comment

    April 23, 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

  2. Collation: Temporary objects and variables: Demonstration

    Leave a comment

    April 21, 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. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. :CONNECT in SSMS

    7

    March 13, 2014 by Kenneth Fisher

    Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from …
    Continue reading

  10. 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

Follow

Get every new post delivered to your Inbox.

Join 173 other followers