Monthly Archives: November 2012

  1. Creating an empty table from a SELECT statement

    11

    November 26, 2012 by Kenneth Fisher

    I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W. …
    Continue reading

  2. CTEs beyond SELECT

    3

    November 20, 2012 by Kenneth Fisher

    The other day I was writing a query to pull some DMV information and I ended up using several CTEs …
    Continue reading

  3. Looping through multiple servers in SSIS Part 3

    21

    November 15, 2012 by Kenneth Fisher

    Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers …
    Continue reading

  4. Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text

    3

    November 12, 2012 by Kenneth Fisher

    I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats …
    Continue reading

  5. Looping through multiple servers in SSIS part 2

    Leave a comment

    November 9, 2012 by Kenneth Fisher

    Last week I posted a quick example of looping through multiple servers using SSIS and being in a bit of …
    Continue reading

  6. A review of Knight’s 24-Hour Trainer Microsoft SQL Server 2008 Integration Services

    1

    November 7, 2012 by Kenneth Fisher

    About three years ago my manager came up to me and said “We need someone to learn SSIS, you’re it.”  …
    Continue reading

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

Join 1,614 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013