August 16, 2012 at 1:42 am
hi friends i have small doubt in sql plz tell me answer
A database that has been used in production is in need of analysis to attempt to make performance improvements. Which of the following is likely to improve performance ? (if correctly implemented)
• Table partitioning
• Covering indexes
• Triggers
• RAID 5
. c2 security
which one currecct and tell me reasion
August 16, 2012 at 1:58 am
Interview question? Homework?
Which do you think has an effect on performance? Actually, what do you think each one does?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2012 at 4:26 am
These questions really sound like either an interview or homework. If I answer the questions, do I get the pay or the grade?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 16, 2012 at 4:59 am
how can u gues it is interview question? and in case of its interview question why ur not help?ok if u know answer tell me answers its help other wise donot comments unnecessary
August 16, 2012 at 4:59 am
how can u gues it is interview question? and in case of its interview question why ur not help?ok if u know answer tell me answers its help other wise donot comments unnecessary
August 16, 2012 at 5:12 am
asranantha (8/16/2012)
how can u gues it is interview question? and in case of its interview question why ur not help?ok if u know answer tell me answers its help other wise donot comments unnecessary
Because they sound like interview questions.
And no, I'm not providing interview answers because if you don't know something in an interview your answer should be "I don't know." An interview is meant to gauge the level of knowledge that you have and well you're going to be able to do the job that you're interviewing for. If I provide you with good answers, you're basically cheating your way into that job. Since I've spent years interviewing people for SQL Server positions, I very much want to know that they know the answers to the questions I'm asking, not that they are cheating. If I provide the answers for you, I should be receiving your pay because you're getting the job based on my knowledge and ability, not your own.
Same thing goes for homework. We get people all the time stuck on their homework. We help. But, occasionally, we get people who just want an answer for their homework. The amount of work they've done is transcribing the question and they want a full answer, not just help getting over a tough concept or confusing aspect. For the latter, all sorts of help is available. For the former, nope.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply