Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: September 2012

DBMail on a cluster

I’ve always found clusters a pain in the neck.  For my latest pain I just spent the last 2 days debugging DBMail on an instance on a cluster.  To the best of my ability everything appeared set up correctly but when I tried a test email it wouldn’t send.  The… Read more

0 comments, 280 reads

Posted in SQLStudies on 26 September 2012

Using a TVP instead of Dynamic SQL to pass a list into a SP

A couple of days ago I read Steve Jones’ blog on creating a user defined table type.  This reminded me that I had just recently been reading about TVPs (Table Valued Parameters) which require user defined table types.  Steve wondered about how useful the concept of user defined table… Read more

2 comments, 526 reads

Posted in SQLStudies on 25 September 2012

Funny results from OPTIMIZE FOR AD HOC WORKLOADS

I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers.  When I went back and looked at sys.dm_exec_cached_plans the next day I had a bit of a shock.  There were over 9000 compiled plans with only one use.  I had thought that… Read more

2 comments, 766 reads

Posted in SQLStudies on 18 September 2012

EXECUTE AS USER = ‘Somebody else’

As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table, and the ability to juggle.” (In case anyone is interested the last can be granted by adding the user to the db_juggling role.)  I’m going to guess a… Read more

0 comments, 362 reads

Posted in SQLStudies on 10 September 2012

sp_helptext

My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and system tables/functions to using the GUI. I’ll look for the table I want in sys.tables, stored procedures in sys.procedures etc. This preference is probably why, when I found this little… Read more

3 comments, 1,829 reads

Posted in SQLStudies on 2 September 2012