Tag Archives: sql statements

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

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

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

  5. Negative session_ids

    2

    January 27, 2014 by Kenneth Fisher

    I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
    Continue reading

  6. The “most_recent_sql_handle” column

    1

    January 22, 2014 by Kenneth Fisher

    While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in …
    Continue reading

  7. Guid vs Identity columns (Ints)

    7

    January 13, 2014 by Kenneth Fisher

    I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary …
    Continue reading

  8. Undocumented functionality in FORMATMESSAGE

    Leave a comment

    December 9, 2013 by Kenneth Fisher

    I was reading a rather interesting post on stackexchange “Why is % a forbidden char in a THROW message?” (which …
    Continue reading

  9. Insert into a table using only default values

    3

    December 4, 2013 by Kenneth Fisher

    A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value …
    Continue reading

  10. Finding active DTS packages

    Leave a comment

    November 27, 2013 by Kenneth Fisher

    DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 163 other followers