sql interview q's

[gaylo565]

I have a job interview for an SQL developer position next week and I was curious as to what sort of technical questions the interviewers might ask. The job is for ms SQL development implementing .NET and C# as well. I am fairly comfortable with the C# and .NET having had prior experience in both, however I have learned most of my SQL through school classes, reading literature and creating personal projects. If anyone has some good interview questions that they were asked at interview time or that they know are common interview questions I could use a few examples so I know what to expect.

[WingedPanther]

One of my first questions would be: what projects have you done that used MS SQL?
Do you know how much SQL Server administration you will be expected to do? DTS could be important, depending on the details. SQL syntax, getting meta-data, etc may also be relevant. Knowing when to use a sub-select and when to use a loop in an application can be very relevant for performance issues. I would try to be aware of those concepts and be prepared for questions on them.

[gaylo565]

Thanks Jordan I work in HR right now and am sure I can handle all the non tech related questions. I was just a bit nervous about what they might ask.

[veridicus]

In addition to what's already been said, you may be asked about when to choose a cursor over a standard query. Or the differences between client-side and server-side cursors (although that's a little old these days). You may be asked about the basic types of database replication and the issues that arise with each.