Index Black Ops Series

Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats.  The series investigates how the columns in the DMV are populated and demonstrates how to aggregate values in the DMV. The posts in this series are: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 … Continue reading Index Black Ops Series

Aggregating With Correlated Sub-Queries #tsql2sday

It’s that time of the month again.  Time for T-SQL Tuesday!  This month’s event is being hosted by Jes Schultz Borland (Blog|@grrl_geek).  The topic that she chose for this month is aggregates. The Dilemma A few months ago, a client I was working with had a dilemma with one of their search queries.  A query … Continue reading Aggregating With Correlated Sub-Queries #tsql2sday

FileSystemHelper Update and Release

About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients.  As a result, I had created the CodePlex project FileSystemHelper.  I blogged about it back then and had meant to get back to it with a number of updates but that never really happened.  Along the … Continue reading FileSystemHelper Update and Release

Can You Dig It? – Plan Cache Series

A few PASS Summit’s ago, I became interested in the information available in the Plan Cache.  As part of that interest, I started digging into the plan cache to  find out what is there and available to be pulled out. Some of those investigations led to a few presentations; which have in turn led to … Continue reading Can You Dig It? – Plan Cache Series

Can You Dig It? – Find Estimated Cost

Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. It’s the eighth post in the plan cache series.  I hadn’t expect to take as many days off from this due to the 31 Days of SSIS, but that one had a stricter time table that I … Continue reading Can You Dig It? – Find Estimated Cost

31 Days of SSIS Conclusion

Last month, I published the 31 Days of SSIS blog series.  As a conclusion to that series, I wanted to post a wrap-up post, but quite honestly I was a little out of steam on February 1. I wanted to thank those that have read or will read the posts in this series.  It was … Continue reading 31 Days of SSIS Conclusion

31 Days of SSIS – SSIS Naming Conventions (31/31)

We’re at the thirty-first, and last, post for the 31 Days of SSIS.   The series started with an introductory post.  This series has been a collection of the things that I’ve picked up over the years in my work with SSIS.  I figured I’d end this series with a best practice that I’ve not often … Continue reading 31 Days of SSIS – SSIS Naming Conventions (31/31)

31 Days of SSIS – Importing Execution Plans (30/31)

Almost time to wrap up the 31 Days of SSIS.  We are down to just two more posts with today’s post being number thirty.  If you’re behind on this series, check out the introductory post. This morning’s one day late twenty-ninth post went over the use of the Export Column transformation.  Since we discussed that … Continue reading 31 Days of SSIS – Importing Execution Plans (30/31)

31 Days of SSIS – Exporting Execution Plans (29/31)

A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still coming out.  And if things go right, I’ll be caught up where I need to be by the end of the day.  If you’re behind on this series, check out the introductory post. File Export Requirements When considering … Continue reading 31 Days of SSIS – Exporting Execution Plans (29/31)