Monthly Archives: April 2013

  1. INFORMATION_SCHEMA the un-sung system views

    12

    April 29, 2013 by Kenneth Fisher

    I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. …
    Continue reading

  2. How do I tell the stored procedure name from inside the stored procedure?

    1

    April 24, 2013 by Kenneth Fisher

    I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re …
    Continue reading

  3. Who writes your documentation?

    4

    April 22, 2013 by Kenneth Fisher

    I’ve been thinking recently about who writes the best documentation. Not including a professional technical writer (although they actually do …
    Continue reading

  4. Calculating the length of a string (Len vs DataLength)

    3

    April 14, 2013 by Kenneth Fisher

    This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers …
    Continue reading

  5. How do I use a variable in an IN clause?

    10

    April 8, 2013 by Kenneth Fisher

    I see this question in one form or another a lot. I’ve seen this or something like it probably half …
    Continue reading

  6. UNPIVOT a table using CROSS APPLY

    18

    April 1, 2013 by Kenneth Fisher

    I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already …
    Continue reading

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

Join 1,682 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013