SQL Server Interview Questions

[Kamlesh]

Hi,

Is there any website which lists the various SQL Server related
questions which might be helpfull for interviews. I am looking for
one that contains complex Queries that includes all kinds of operators
like GROUP BY, HAVING etc...

Regards,
Kamlesh

[Simon Hayes]

ka*********@yahoo.com (Kamlesh) wrote in message news:<26**************************@posting.google. com>...

Hi,

Is there any website which lists the various SQL Server related
questions which might be helpfull for interviews. I am looking for
one that contains complex Queries that includes all kinds of operators
like GROUP BY, HAVING etc...

Regards,
Kamlesh

I'm not sure if this is exactly what you're looking for, but it should be helpful:

http://vyaskn.tripod.com/iq.htm

Simon

[Christopher J Nelson]

sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...

ka*********@yahoo.com (Kamlesh) wrote in message news:<26**************************@posting.google. com>...

Hi,

Is there any website which lists the various SQL Server related
questions which might be helpfull for interviews. I am looking for
one that contains complex Queries that includes all kinds of operators
like GROUP BY, HAVING etc...

Regards,
Kamlesh

I'm not sure if this is exactly what you're looking for, but it should be helpful:

http://vyaskn.tripod.com/iq.htm

Simon

When I interviewed with a company called SmartReply in Irvine, CA, the
idiot actually sent me a document with these exact same questions on
them. I didn't look at the answers, I just answered them honestly but
I could have cheated on it w/ ease.

Christopher J. Nelson

[Lyndon Hills]

On 24 Feb 2004 11:30:05 -0800, ja*******************@yahoo.com
(Christopher J Nelson) wrote:

sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...

ka*********@yahoo.com (Kamlesh) wrote in message news:<26**************************@posting.google. com>...

> Hi,
>
> Is there any website which lists the various SQL Server related
> questions which might be helpfull for interviews. I am looking for
> one that contains complex Queries that includes all kinds of operators
> like GROUP BY, HAVING etc...
>
> Regards,
> Kamlesh

I'm not sure if this is exactly what you're looking for, but it should be helpful:

http://vyaskn.tripod.com/iq.htm

Simon

When I interviewed with a company called SmartReply in Irvine, CA, the
idiot actually sent me a document with these exact same questions on
them. I didn't look at the answers, I just answered them honestly but
I could have cheated on it w/ ease.

Christopher J. Nelson

The microsoft SQL Server exam might have some straight sql questions
but most of it was about tuning, profiling, file structure, indexes,
backup, permissions and so on.

If you want some sample sql scenarios/puzzles you could try and find
some of Joe Celko's columns on the web www.dbmsmag.com would be a good
place to start.

[Vyas]

I've been hearing from a lot of people that interviewers are using my
questions in DBA interviews :-) Funny thing is, interviewees are also
reading the same page ;-)
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm


"Christopher J Nelson" <ja*******************@yahoo.com> wrote in message
news:97**************************@posting.google.c om...
sq*@hayes.ch (Simon Hayes) wrote in message
news:<60**************************@posting.google. com>...

ka*********@yahoo.com (Kamlesh) wrote in message news:<26**************************@posting.google. com>...

Hi,

Is there any website which lists the various SQL Server related
questions which might be helpfull for interviews. I am looking for
one that contains complex Queries that includes all kinds of operators
like GROUP BY, HAVING etc...

Regards,
Kamlesh

I'm not sure if this is exactly what you're looking for, but it should be

helpful:
http://vyaskn.tripod.com/iq.htm

Simon

When I interviewed with a company called SmartReply in Irvine, CA, the
idiot actually sent me a document with these exact same questions on
them. I didn't look at the answers, I just answered them honestly but
I could have cheated on it w/ ease.

Christopher J. Nelson

[--CELKO--]

Buy a copy of my SQL PUZZLES & ANSWERS.

[Kamlesh Rao]

Hello,

Thanks for all of your response. I actually meant Puzzles/Questions
which are related to the Structured Query Language. I am sorry for the
confusion that made you all think that I am asking for Interview
questions. :)

I have checked with few Book Stores here in India and couldn't find that
book here. :(

Regards,
Kamlesh
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!