SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005


SQL Server 2005

Author
Message
shamshudheen
shamshudheen
SSC Veteran
SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)SSC Veteran (218 reputation)

Group: General Forum Members
Points: 218 Visits: 211
hi steve

i am using sql 2000. how can i answer this question?
Better seperate questions for sql 2000 and 2005, since i could not answer well.
hope you do the needfull
Anipaul
Anipaul
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7371 Visits: 1407
Resource is a very much a system database.

Read these:

http://msdn.microsoft.com/en-us/library/ms178028.aspx: System Databases
http://weblogs.sqlteam.com/mladenp/archive/2007/03/12/60132.aspx :MsSqlSystemResource - SQL Server 2005's 5th system database



Jamie-2229
Jamie-2229
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 838
When I was attending school [nearly a million years ago], I never appreciated trick questions and at this stage in my life I cannot recall any of those questions. On the other hand, there were good questions my teachers and professors asked that still remain in my head in my the same way a good joke remains easy to recall. I'm not convinced that trick questions teach people anything other than humility.

Jamie
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39876 Visits: 38563
Jamie Longstreet (5/9/2008)
When I was attending school [nearly a million years ago], I never appreciated trick questions and at this stage in my life I cannot recall any of those questions. On the other hand, there were good questions my teachers and professors asked that still remain in my head in my the same way a good joke remains easy to recall. I'm not convinced that trick questions teach people anything other than humility.


Are you calling this question a trick question? I think it was a very good question, it is in fact a question someone I know asks potential employees in an interview for DBA positions.

Cool

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Jamie-2229
Jamie-2229
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 838
Lynn,

I think it has the possibility of being a better question. Like everything that gets put out here on the web, I expect a good deal of thought should be required before it goes out.

Speaking of Interviews:
I get lots of weird questions at interviews. Here are a couple of examples (which incidentally, were interviews that did not hire me and were during the last year):

When you open up the Visual Studio 2005 interface, what do you do?

then later in the interview:

When you open SQL manager, what do you do?

And frankly, what I did, was bit my tongue because I wasn't sure if it was a joke or not, then went home, told my wife and had a few laughs.

Jamie

Jamie
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39876 Visits: 38563
So, would you improve the question, or the answers provided? To take this into an interview environment, I would be looking to see if someone knew that there were 5 system databases: master, model, msdb, tempdb and resource. It wouldn't matter as much to me if they could provide me with the logical or physical names. You can look that up in BOL or in the file system.

Cool

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Jamie-2229
Jamie-2229
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 838
I would certainly try to improve the question. Question can trip someone up when they are shot as a curve ball - it doesn't mean the person answering the question isn't qualified to hit the ball. It means the experience of that person is different from that of the pitcher.

For example, post a question on line that is important for everyone to understand, but posted it in a way that the person reading the question can't understand, the answer won't come easily. Now post in a way that everyone understands... wow, the hits just keep on coming...

Jamie
Lynn Pettis
Lynn Pettis
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39876 Visits: 38563
So how would you have written this question?

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Tom Garth
Tom Garth
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1255 Visits: 1499
Lynn Pettis (5/9/2008)
So, would you improve the question, or the answers provided? To take this into an interview environment, I would be looking to see if someone knew that there were 5 system databases: master, model, msdb, tempdb and resource. It wouldn't matter as much to me if they could provide me with the logical or physical names. You can look that up in BOL or in the file system.

Cool


So I'm reading all of this feedback intently because I've never heard of the Resource database (I've been using 2k5 since beta), and now I find out I would fail your job interview question.Crying

I guess I want to know what is there that is worthwhile about knowing about it's existence? When you setup a Maintenance plan for the System databases, does it include the Resource database? Has anyone in this discussion ever gotten any use from the Resource database, or from knowing of it's existence?Ermm

Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

Jamie-2229
Jamie-2229
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3144 Visits: 838
I suspect there would be numerous ways to pose the question... maybe
more inadvertantly, like "Have you ever heard of a Resource database?"

I'm not poking fun at the question... all questions are good questions in a sense... mostly, all questions are better than no questions, but there are also some "better" questions. I'm here reading and answering them.

But it seems important to remember it isn't a contest. For the sake of an interview, it's a chance to get to know what the person on the other end of the table is like and whether they are skilled enough to do the job more than whether they are MENSA qualified.

I'm getting deep here... no offense intended for MENSA folks!

Jamie
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search