Monthly Archives: September 2012
-
DBMail on a cluster
Leave a commentSeptember 26, 2012 by Kenneth Fisher
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days …
Continue reading -
Using a TVP instead of Dynamic SQL to pass a list into a SP
2September 25, 2012 by Kenneth Fisher
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me …
Continue reading -
Funny results from OPTIMIZE FOR AD HOC WORKLOADS
2September 18, 2012 by Kenneth Fisher
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I …
Continue reading -
EXECUTE AS USER = ‘Somebody else’
Leave a commentSeptember 9, 2012 by Kenneth Fisher
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table, …
Continue reading -
sp_helptext
5September 2, 2012 by Kenneth Fisher
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and …
Continue reading
