Tag Archives: data types

  1. The sysname datatype defaults to not NULL.


    August 26, 2021 by Kenneth Fisher

    The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for …
    Continue reading

  2. Right sizing int : T-SQL Tuesday #136


    March 9, 2021 by Kenneth Fisher

    Brent Ozar (blog|twitter) is our host this month, which will make this the most popular #tsql2sday to date I’m sure. …
    Continue reading

  3. What is the datatype SQL_VARIANT


    April 16, 2020 by Kenneth Fisher

    The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. …
    Continue reading


    Leave a comment

    January 27, 2020 by Kenneth Fisher

    If you read the title to this post and your first thought was That’s not SQL is it? then you …
    Continue reading

  5. SQL Homework – July 2019 – Table Size

    Leave a comment

    July 1, 2019 by Kenneth Fisher

    In general this homework series is meant to give you ideas of things to play with that most if not …
    Continue reading

  6. Data Types Word Search


    September 26, 2018 by Kenneth Fisher

    Just for fun here is a word search with all of the data types available in SQL Server. Well, two …
    Continue reading

  7. Using LEN wrong.


    June 2, 2016 by Kenneth Fisher

    I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster) …
    Continue reading

  8. varchar(1) VS char(1)


    February 15, 2016 by Kenneth Fisher

    The other day I made a somewhat flip coment on twitter. (I know, everyone is shocked right?) varchar(1) Really? It’s …
    Continue reading

  9. How are COALESCE and ISNULL different?


    August 7, 2013 by Kenneth Fisher

    At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2) …
    Continue reading

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

Join 3,653 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013