-
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 -
fn_OBJECT_TYPE
4October 19, 2012 by Kenneth Fisher
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist …
Continue reading -
A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan
1October 15, 2012 by Kenneth Fisher
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the …
Continue reading -
Multiple CTEs
10October 9, 2012 by Kenneth Fisher
Multiple CTEs It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you …
Continue reading -
Active flag on the TCP/IP Properties page of SQL Server Configuration Manager
1October 5, 2012 by Kenneth Fisher
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 