Post reply

SQL Server Interview Questions And Answers

  • February 17, 2011 at 10:57 am

    #1288402

    This is the questions which other than the general indexes questions.

    What are criteria to define covering index and how we create it?

    Please provide some details for this question.

    For Sql Server Interview Questions and Answer

    http://sqlserverquest.blogspot.com[/url%5D

    Randheer Singh

    ----------------------------------
    CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

    http://www.sqlserverquest.com/p/ssrs-interview-questions.html
    http://www.sqlserverquest.com/p/ssis-interview-questions.html
    http://www.sqlserverquest.com/p/tsql-interview-questions.html

  • February 17, 2011 at 10:59 am

    #1288403

    Randheer (2/17/2011)

    This is the questions which other than the general indexes questions.

    What are criteria to define covering index and how we create it?

    Please provide some details for this question.

    Are you asking us so that you can update your blog? If so, do some research, start with the indexing articles I wrote for this site.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 17, 2011 at 11:00 am

    #1288404

    Randheer (2/17/2011)

    This is the questions which other than the general indexes questions.

    --

    This index question does not scan.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • February 17, 2011 at 11:32 am

    #1288416

    Randheer (2/17/2011)

    This is the questions which other than the general indexes questions.

    What are criteria to define covering index and how we create it?

    Please provide some details for this question.

    For Sql Server Interview Questions and Answer

    http://sqlserverquest.blogspot.com[/url%5D%5B/quote%5D

    It has to cover the query, and it's created the same way you create any index. I guess I'm not clear on what you're asking here. The only difference between a covering index and a non-covering index is the match-up between columns in the query and columns in the index being complete or incomplete.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 17, 2011 at 11:57 am

    #1288430

    What does all of this have to do with Integration Services?


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • February 17, 2011 at 11:59 am

    #1288433

    Alvin Ramard (2/17/2011)

    What does all of this have to do with Integration Services?

    Not a thing.

    It's all about how to ignore that job prep is a superset of interview prep. So as long as it stays on the topic of getting jobs you really can't do, who cares what piece of that it's about?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • March 13, 2011 at 12:21 pm

    #1298139

    You should be prepared before going to the interview and I believe there is no harm if you know what you are ignoring while doing your regular work.

    so get prepared for interview before going to the interview.

    check out basic interview questions on http://sqlserverquest.blogspot.com

    Randheer Singh

    ----------------------------------
    CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

    http://www.sqlserverquest.com/p/ssrs-interview-questions.html
    http://www.sqlserverquest.com/p/ssis-interview-questions.html
    http://www.sqlserverquest.com/p/tsql-interview-questions.html

  • March 13, 2011 at 12:34 pm

    #1298142

    Randheer (3/13/2011)

    check out basic interview questions on http://sqlserverquest.blogspot.com

    You might want to check the accuracy and readability before you go promoting those questions for people to use in interviews.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 28, 2011 at 11:03 am

    #1304480

    Thanks for your valuable comments.

    I have earlier made changes in answers and made them correct...........

    currently working on correctness and quality of all Questionnaires which I am submitting in my blog.

    Randheer Singh

    ----------------------------------
    CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

    http://www.sqlserverquest.com/p/ssrs-interview-questions.html
    http://www.sqlserverquest.com/p/ssis-interview-questions.html
    http://www.sqlserverquest.com/p/tsql-interview-questions.html

  • June 10, 2011 at 4:56 am

    #1336886

    Thanks Randheer;

    These questions for sql developer are really helpfull

    Tarun Madaan
    Artificer
    Http://artificer.in

  • June 10, 2011 at 5:06 am

    #1336889

    Randheer (3/13/2011)

    You should be prepared before going to the interview and I believe there is no harm if you know what you are ignoring while doing your regular work.

    so get prepared for interview before going to the interview.

    check out basic interview questions on http://sqlserverquest.blogspot.com

    At the risk of flogging a dead horse, your first sentence can be paraphrased as:

    "Instead of admitting that there are some things you don't know, because you haven't used them or needed to use them before, why not try to blag your way past interviewers to secure a post for which you are not qualified?"

    Maybe you would choose to hire such a person. Most employers would, I suspect, not.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • June 10, 2011 at 6:25 am

    #1336920

    tarun.him (6/10/2011)

    Thanks Randheer;

    These questions for sql developer are really helpfull

    Be careful about depending on this blog as a resource. Even just looking at today's blog post makes me cringe due to the oversimplification of a topic that will lose you your job opportunity if you rely solely on the information posted.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • June 10, 2011 at 6:44 am

    #1336930

    Brandie Tarvin (6/10/2011)

    tarun.him (6/10/2011)

    Thanks Randheer;

    These questions for sql developer are really helpfull

    Be careful about depending on this blog as a resource. Even just looking at today's blog post makes me cringe due to the oversimplification of a topic that will lose you your job opportunity if you rely solely on the information posted.

    Eish, you're not kidding.

    Randheer, that's such a simplification of normalisation that it's near useless (and wrong on at least one point). Do your readers a favour and take that one down.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 14, 2014 at 3:25 am

    #1679822

    http://skatageri.blogspot.in

    T-SQL/MSBI Knowledge Share Videos : http://www.youtube.com/results?search_query=T+SQL/MSBI+Knowledge+Share+Videos

  • May 14, 2015 at 1:38 am

    #1797757

    Below link contains frequently asked SQL interview questions and answers (MSSQL, Oracle, MySQL)

    SQL interview Questions and answers

    -------------------------------------------------------------------------------------
    CodeGuys,

    Check my website for frequently asked interview questions and answers.

    http://www.techieclues.com

Viewing 15 posts - 16 through 30 (of 33 total)

You must be logged in to reply to this topic. Login to reply