Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OMB
Yak Posting Veteran
88 Posts |
 Posted - 2004-01-15 : 04:32:47
|
Hi AllWe have just started interviewing for a new SQL developer. One of the questions I asked was if they have created triggers all said yes of course. I then asked them how thay would identify if a row had been inserted or deleted none of them could tell me about inserted or deleted tables  . Now I thought this was the only way. Is there another or is it as i thought that they dont know what they are talking about .OMB |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-01-15 : 04:39:31
|
| I'd put 10$ on your second statement...Most of people (developers) I know use SQL server much alike a bag of potatoes (a big bag can hold a lot of them!). |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-15 : 04:57:17
|
| They've probably connected to sql server and maybe written a few select statements and maybe seen triggers or read that they are fired by data changes.Ask them what a clustered index is too - I used to ask deeper questions about indexes but found I neede to start with that.Other trivial questions that everyone should knowWhy does the tr log continue to grow.What causes tempdb to get large.How to find duplicate rows in a table.Then you can start on proper questions.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-01-15 : 09:38:22
|
| Another good question to ask them is about OUTPUT params on Stored procs. Ask them what they are and why they would use them. They are used to get a single value back from a Stored Proc in the most effeciant way possible.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-15 : 10:15:50
|
| The idea is to get outside there area of expertise and see what their response is.It will either be I don't know (they would do research on the job rather than screw up) That's stupid (you are probably outside your area of expertise) BluffAvoid the ones that bluff - the others are ok - especially if they ask what you are expecting.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
OMB
Yak Posting Veteran
88 Posts |
Posted - 2004-01-16 : 07:16:34
|
quote:
Originally posted by X002548
How about some of these:http://www.dbforums.com/t977718.htmlBrett8-)
Excellent thread especially when you have interviewed as many "SQL specialist"  As I have.OMB |
|
|
|
|
|
|
Am I Missing something?