Monthly Archives: December 2014

  1. 2014 in review

    Leave a comment

    December 30, 2014 by Kenneth Fisher

    The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: The Louvre Museum has …
    Continue reading

  2. Finding a common AD group for a set of users.

    8

    December 29, 2014 by Kenneth Fisher

    I work for a large organization that over the last few years has been doing a LOT of reorgs. And …
    Continue reading

  3. Do you want to build an Audit?

    Leave a comment

    December 29, 2014 by Kenneth Fisher

    So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql …
    Continue reading

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

    1

    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

  5. ‘Twas 4:45 Friday

    3

    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

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

  7. DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

    3

    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

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

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

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

    13

    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

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

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013