-
When I get stumped I ….
2October 2, 2012 by Kenneth Fisher
I work with a reasonably large team of DBAs. There are 9 of us and we support not only 70+ …
Continue reading -
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
3September 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’
2September 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
6September 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 -
At Startup SSMS setting
3August 26, 2012 by Kenneth Fisher
I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I …
Continue reading -
keyword DEFAULT
5August 20, 2012 by Kenneth Fisher
In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 