Category Archives: Microsoft SQL Server
-
fn_OBJECT_TYPE
4October 19, 2012 by Kenneth Fisher
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist …
Continue reading -
A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan
1October 15, 2012 by Kenneth Fisher
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the …
Continue reading -
Multiple CTEs
10October 9, 2012 by Kenneth Fisher
Multiple CTEs It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you …
Continue reading -
Active flag on the TCP/IP Properties page of SQL Server Configuration Manager
1October 5, 2012 by Kenneth Fisher
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked …
Continue reading -
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
SQL Studies 