Monthly Archives: November 2012
-
Creating an empty table from a SELECT statement
12November 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 -
CTEs beyond SELECT
5November 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 -
Looping through multiple servers in SSIS Part 3
29November 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 -
Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
4November 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 -
Looping through multiple servers in SSIS part 2
3November 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 -
A review of Knight’s 24-Hour Trainer Microsoft SQL Server 2008 Integration Services
1November 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