Tag Archives: system functions

  1. What is this default trace you speak of?

    4

    June 12, 2014 by Kenneth Fisher

    I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge …
    Continue reading

  2. Escaping from a runaway Logon trigger

    11

    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

  3. Does SQL Server do a CHECKDB during an instance restart?

    11

    May 7, 2014 by Kenneth Fisher

    When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server …
    Continue reading

  4. Why is there a sysobjects when we already have sys.objects?

    2

    May 5, 2014 by Kenneth Fisher

    Once upon a time in a version of SQL far far away we had system tables that were easy to …
    Continue reading

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

    5

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

    3

    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

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

  9. Finding active DTS packages

    9

    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

  10. Finding the metadata for a query

    2

    November 25, 2013 by Kenneth Fisher

    You know I occasionally find it interesting how I learn new things. I was running through a practice test for …
    Continue reading

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

Join 3,746 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013