Monthly Archives: March 2014

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

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

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

  4. Thank you!

    Leave a comment

    March 19, 2014 by Kenneth Fisher

    I won’t be able to make it to the PASS Summit this year but I still consider myself part of …
    Continue reading

  5. Collation: Definition

    3

    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

  6. Start with stupid

    1

    March 17, 2014 by Kenneth Fisher

    True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked …
    Continue reading

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

  8. T-SQL Tuesday #52: Keep your head down!

    1

    March 11, 2014 by Kenneth Fisher

    It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has …
    Continue reading

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

  10. Using SQLFiddle

    2

    March 3, 2014 by Kenneth Fisher

    SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,663 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013