Tag Archives: sql statements

  1. 15 years of experience with Identity columns

    25

    June 4, 2014 by Kenneth Fisher

    An identity column is an auto incrementing column An identity column is typically used as a primary key A primary …
    Continue reading

  2. What is the difference between Money and Decimal(19,4)

    6

    June 2, 2014 by Kenneth Fisher

    One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4). …
    Continue reading

  3. Escaping from a runaway Logon trigger

    Leave a comment

    May 19, 2014 by Kenneth Fisher

    Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
    Continue reading

  4. DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

    7

    April 30, 2014 by Kenneth Fisher

    Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However …
    Continue reading

  5. The default autogrowth settings do NOT come from the Model database.

    1

    April 28, 2014 by Kenneth Fisher

    I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed …
    Continue reading

  6. Collation: Temporary objects and variables: Demonstration

    4

    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

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

  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. Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

    Leave a comment

    January 29, 2014 by Kenneth Fisher

    I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 290 other followers