Interview with the Resource Database

Recently I had a chance to catch up with the Resource Database, which is rare given his reclusive ways as of late.  Today, I bring you the answers you demand.

Me: So mssqlsystemresource, can I call you Resource Database?

RD: Sure, just keep in mind I won’t return your queries.

Me:  So Resource Database, what have you been doing with yourself lately?  Where have you been?  What have you been up to?

RD: Oh, just hanging out behind the scenes.  I don’t like the limelight, I leave that to my friend, TempDB.  Most administrators don’t even know I exist and I like it that way.

Me: Shouldn’t administrators know about you?

RD: NOOOOO!  Next thing you know they will want to query me for data, try to change my settings, and next thing you know they will corrupt me!  I’m not having that.  This is all off the record, right?

Me: Ah, sure.  So what secrets are you hiding?

RD: I mostly work by keeping all the secrets of the system objects, you know sys.objects, I keep all of that stored and sealed up.

Me:  Wait a minute?  We see those in the sys schema of every database.  What gives?

RD: Logically you are correct but physically you are incorrect.  They are mine.  How else do you think you can upgrade SQL Server?  By letting everyone mess with those objects?  I don’t think so!  This interview is over!  I’m outta here!

Me:  Well there you have it folks.  The mysterious Resource Database remains mysterious.  Enjoy!



About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on April 20, 2012, in Funhouse, SQL Schoolhouse and tagged . Bookmark the permalink. 1 Comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: