Category Archives: Microsoft SQL Server

  1. Playing with the log – VLF order while growing the log

    Leave a comment

    December 17, 2014 by Kenneth Fisher

    The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of …
    Continue reading

  2. ‘Twas 4:45 Friday

    Leave a comment

    December 16, 2014 by Kenneth Fisher

    ‘Twas 4:45 Friday, and all through the office not a creature was stirring, not even the bosses. The code was …
    Continue reading

  3. Does a clustered index sort the rows within a page

    Leave a comment

    December 15, 2014 by Kenneth Fisher

    This is just something I was curious about. I ran my tests and got an answer and now I thought …
    Continue reading

  4. DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

    2

    December 11, 2014 by Kenneth Fisher

    I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do …
    Continue reading

  5. TSQL Tuesday #61: Giving Back, you gain more than you give.

    Leave a comment

    December 9, 2014 by Kenneth Fisher

    Almost four months ago I posted my goals for the next year in my two year anniversary post. I pretty …
    Continue reading

  6. INSERT INTO SELECT vs SELECT INTO

    2

    December 3, 2014 by Kenneth Fisher

    INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and …
    Continue reading

  7. Using a date or int column as the clustered index.

    9

    December 1, 2014 by Kenneth Fisher

    The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on …
    Continue reading

  8. Who’s on call

    Leave a comment

    November 26, 2014 by Kenneth Fisher

    Originally posted on SQL Studies:
    Every morning we have a daily meeting and my manager asks who’s on call. And every…

  9. Putting sp_ at the beginning of your stored procedure.

    1

    November 24, 2014 by Kenneth Fisher

    Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So …
    Continue reading

  10. You don’t really need ORDER BY do you?

    6

    November 19, 2014 by Kenneth Fisher

    You see dozens of blog posts and articles about how the order of a result set is not guaranteed without …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 527 other followers