See my post on the 4th page of this thread, where I give more detail about using xp_execresultset in place of a cursor.  In addition, there are many good examples...

I have personally discovered that table variables can often be slower than temp tables.  In addition, with temp tables you can create indexes, which often speed up performance significantly (minus...

Why not use xp_execresultset? 

E.g.,

EXEC master..xp_execresultset N'SELECT

''EXEC dbo.my_procedure '' + CAST(param_1 AS VARCHAR) + '','' + CAST(param_2 AS VARCHAR)''

FROM (SELECT param_1, param_2 FROM MyDB..MyTable) temp

',N'MyDB'

This keeps...

You're remark about adding a column being a "minimal" change made me think of something that should itself be listed as a bad practice: not specifying a column list in INSERT statements...

Here's a crosstab query I created:

http://www.sqlservercentral.com/scripts/contributions/936.asp

Hope this helps somewhat.

Here's a solution I came up with a few weeks ago:

http://www.sqlservercentral.com/scripts/contributions/936.asp

This is a great article, and in most cases this is a quick and effective way to determine the number of rows. However, there is one drawback. The...

In my experience, every "DBA" position I've worked at has required a whole lot more than the standard SQL DBA skillset. In fact, at each job, the vast majority...