| Author |
Topic |
|
vasanthhepsy
Starting Member
48 Posts |
 Posted - 2007-12-10 : 03:57:32
|
| Dear All,Could anyone guide me to prepare for the Interview in SQL SERVER 2005.I have studied the relevant things from background knowledge from the SQL Server books. But is there any specific areas in which I have to concentrate for the sake of Interview?Thanks in Advance. |
|
|
Hariarul
Posting Yak Master
160 Posts |
Posted - 2007-12-10 : 04:06:47
|
| Focus on the fundamentals.Try to explain the real time scenarios you have faced. For some basic questions:http://vyaskn.tripod.com/iq.htmhttp://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/ |
 |
|
|
vasanthhepsy
Starting Member
48 Posts |
Posted - 2007-12-10 : 19:02:07
|
| Thanks for the reply.Is there any other things related to Interview apart from the the one notified?Once again thanks |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
vasanthhepsy
Starting Member
48 Posts |
Posted - 2007-12-10 : 20:37:39
|
| Yes Jeff Certainly, without any doubt I am qualified |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-10 : 21:51:11
|
| Then just take easy. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-10 : 22:50:11
|
shower and shave beforehand. show up at least 10 mins early. don't stare at the ground when you are talking. research the company beforehand so you know something about what they do.
elsasoft.org |
|
|
|
vasanthhepsy
Starting Member
48 Posts |
Posted - 2007-12-11 : 05:38:32
|
| Thanks so far for the preparatory session and suggestions |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-12-11 : 09:25:11
|
| usually they ask you a lot about performance issues that you might have handled. If not, pick up something from the books, cook up a great story about how you solved a performance issue and you will score there.They are pretty brutal about perfmon counters especially "Buffer Cache hit Ratio" is their real star. They also have started asking a lot of times, questions on Locks, Lock escalation and types of isolation levels. BOL has all that information. and no matter what happens....if the interviewer is not a developer, remember to crack a joke or take a jibe at developers in general and of course, keep your eyes off the pretty interviewer's assets.All the best.RegardsParesh MotiwalaBoston, USA |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-12-11 : 09:31:36
|
quote:
Originally posted by vasanthhepsy
Yes Jeff Certainly, without any doubt I am qualified
Then relax! Be confident in your abilities and you will be fine. Let us know how it goes.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
vasanthhepsy
Starting Member
48 Posts |
Posted - 2007-12-11 : 17:12:58
|
Thanks Everyone who strive to give all your commentsSure Jeff. |
|
|
|
sqlsquirrel
Starting Member
21 Posts |
Posted - 2007-12-11 : 17:33:37
|
| Also take note... I have been giving interviews and I ask the candidates to tell me what is new in SQL Server 2005? If the candidate can give me at least 2 new improvements\additions (but would be looking for 3 improvements\additions) then the candidate passed that question.Good Luck!Brett DavisSenior SQL Server DBAFor more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-12-11 : 20:33:22
|
quote:
cook up a great story about how you solved a performance issue
Truth and nothing but the truth.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
vasanthhepsy
Starting Member
48 Posts |
Posted - 2007-12-12 : 17:20:24
|
| Thanks very much to ALL who helped me in preparing for the interview and the invaluable tips and everything worked out well. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-12 : 17:26:56
|
quote:
Originally posted by sqlsquirrel
Also take note... I have been giving interviews and I ask the candidates to tell me what is new in SQL Server 2005?
I'd answer: "nothing, the product is 2 years old now, wanna hear what's new in 2008?".Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-12-12 : 17:34:03
|
Tell them a story about how you caused a huge problem and then came out looking like a hero when you fixed it.  CODO ERGO SUM |
|
|
|
vasanthhepsy
Starting Member
48 Posts |
Posted - 2007-12-12 : 17:43:22
|
quote:
Originally posted by Michael Valentine Jones
Tell them a story about how you caused a huge problem and then came out looking like a hero when you fixed it. Fortunately  There is no such incident happened in all my ALL my previous positionCODO ERGO SUM
|
|
|
|
|
Interview related