SQL Server Interview Questions And Answers

  • My Blog SQLServerQuest.com is getting updated with new interview questions which will help you to understand the various aspect of SQL Server.

    Revisit those SQL Server interview questions for better understanding.

    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

  • All of the links I clicked on in your T-SQL site leader to "blogger.com/about".

    Did you ever fix the delete vs truncate answers?  They were really wrong at the beginning of this post.

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Thanks Jeff for highlighting the issues. I also couldn't understand how it happened as every thing was working fine. I will correct it.

    Also my answers are also in update mode. let me fix and reupdate on this forum. Open for any of the suggestion.

    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

  • Your workplace asks some interesting questions, but anyone reading this thread should be aware that it's specific to your workplace and other employers (like my team) doesn't ask questions like these. This reads more like a "you passed an exam now prove it" than it does "you have workplace experience solving problems and working as a team, tell us about it" kind of site.

    There are also just too many "define this" questions where the answers do anything but define the objective in the question to make me comfortable recommending your blog to anyone. And if anyone came to one of my interviews armed with this information, they would not get a second interview.

    I understand you're trying to make it easier for people interviewing for DBA jobs, but people who know SQL Server shouldn't have to memorize BOL to be able to get their foot in the door of a workplace that values experience and team work over memorization.

    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.

Viewing 4 posts - 31 through 34 (of 34 total)

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