Tag Archives: code language

  1. Working with “special” names

    4

    October 19, 2015 by Kenneth Fisher

    What do you do when you need to use a special character in a name? Well, I guess I should …
    Continue reading

  2. Updating a view

    2

    September 30, 2015 by Kenneth Fisher

    I was recently asked how to update views. Specifically the question was about using triggers to update a view. So …
    Continue reading

  3. “sql_handle” is not a recognized table hints option.

    Leave a comment

    September 23, 2015 by Kenneth Fisher

    I’ve you’ve run a query similar to the following: And gotten an error similar to: Msg 321, Level 15, State …
    Continue reading

  4. Using @@ROWCOUNT can be a bit tricky

    2

    September 16, 2015 by Kenneth Fisher

    @@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently …
    Continue reading

  5. Getting and storing a high precision datetime

    5

    August 13, 2015 by Kenneth Fisher

    Earlier today I was working on a project where I was recording some time stamps. In order to get as …
    Continue reading

  6. A pattern to match correctly on a value or a NULL

    3

    August 5, 2015 by Kenneth Fisher

    As you may have noticed if you read my blog I learn a lot from trolling various forums. In this …
    Continue reading

  7. Adding, altering or removing multiple columns from a table

    2

    April 16, 2015 by Kenneth Fisher

    I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing …
    Continue reading

  8. What is a CTE

    1

    April 6, 2015 by Kenneth Fisher

    CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade. …
    Continue reading

  9. Why not NOLOCK?

    5

    March 18, 2015 by Kenneth Fisher

    Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
    Continue reading

  10. There are #temp tables and then there are ##temp tables.

    Leave a comment

    March 16, 2015 by Kenneth Fisher

    Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly …
    Continue reading

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

Join 1,232 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,232 other followers