Monthly Archives: October 2013

  1. Adding a column to a table with a default (NULL vs NOT NULL)

    3

    October 30, 2013 by Kenneth Fisher

    There are lots of ways to learn new things, or be reminded of old things. One of my favorites is …
    Continue reading

  2. Change in SQL 2012 SSMS grid output behavior

    Leave a comment

    October 28, 2013 by Kenneth Fisher

    It’s one of those things that always aggravated me but not really enough to complain about. When you run a …
    Continue reading

  3. Unexpected truncation in FETCH

    Leave a comment

    October 23, 2013 by Kenneth Fisher

    Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything …
    Continue reading

  4. A look at comments

    13

    October 21, 2013 by Kenneth Fisher

    Everyone knows that we should include comments in our code right? On the other hand the vast majority of us …
    Continue reading

  5. Query to compare indexes between two tables

    Leave a comment

    October 16, 2013 by Kenneth Fisher

    We have a set of databases at my office that use the load and swap method of loading data with …
    Continue reading

  6. Why you should know how to script as well as use the GUI

    Leave a comment

    October 14, 2013 by Kenneth Fisher

    Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out …
    Continue reading

  7. I’ve refreshed a test database from prod but now the users can’t access it.

    4

    October 9, 2013 by Kenneth Fisher

    This happens to me all the time. I get a request from a developer to overwrite the test copy of …
    Continue reading

  8. T-SQL Tuesday #47: Your Best SQL Server SWAG

    Leave a comment

    October 7, 2013 by Kenneth Fisher

    It’s time for T-SQL Tuesday again and this time Kendal Van Dyke is asking for Your Best SQL Server SWAG. …
    Continue reading

  9. Use TOP instead of SET ROWCOUNT

    8

    October 7, 2013 by Kenneth Fisher

    Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however …
    Continue reading

  10. Filtering Object Explorer

    2

    October 2, 2013 by Kenneth Fisher

    I absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the …
    Continue reading

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

Join 2,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013