Archives: July 2013
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool but to be honest it feels like it was written not just one committee but several different ones. And I won’t say they weren’t talking to each other (I kind… Read more
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of the stored procedures and queries that I’ve ended up using. I’ve added notes to most of them to help explain and work with them.
USE msdb GO -- Check that…
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused by my own stupidity. Shortly after that I got to go to the Pass Rally in Dallas and had an even more fantastic time (no travel problems this time). My… Read more
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle dynamic SQL. Honestly I found the idea interesting and coming up with a solution rather fun.
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead to one of the most amusing SQL Blogs I’ve ever read. It’s completely serious, and yet the trick discussed so fits my sense of humor I couldn’t help but laugh. Read more
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting.
First here is a script to create a simple partitioned table so you can follow along if you like.
CREATE PARTITION FUNCTION fn_PartTestFunction (int) AS RANGE LEFT FOR VALUES (1,2,3,4) GO…
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is also a limited amount of control flow available in SQL Agent jobs. Here are a couple of examples of how it works and what you can do with it.
First… Read more
A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions for good habits when writing dynamic SQL. Along the same lines, this is my methodology for writing Dynamic SQL. Again this has nothing to do with when it is a… Read more