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!