Category Archives: Microsoft SQL Server
-
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 -
Looping through multiple servers in SSIS
16October 31, 2012 by Kenneth Fisher
This is just a quickie post to answer a question on how to loop through multiple servers in SSIS. There …
Continue reading -
How do I find all stored procedures or views that use a specific table?
3October 26, 2012 by Kenneth Fisher
Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views …
Continue reading -
I can connect to my instance locally but not remotely
4October 23, 2012 by Kenneth Fisher
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. …
Continue reading
SQL Studies 