You must Sign In to post a response.
  • Category: SQL Server

    Interview question on Database


    Recently I attended an interview call for .net developer position. I answered most of the questions.
    But Interviewer asked me 2 database related questions and I am not able to convince him.

    Can you give me proper explanation of below questions:

    1. Explain different database optimization techniques with proper example?
    2. During select queries we use locks for tables. So definitely it degrade the performance. So is there any other method available instead of locking table?

    Ashish Mayekar
  • #756283

    Kindly take a look up the following mentioned Link for Locking the Sql Tables. It may help u..


    For Database Optimization,


  • #756285
    Hi Ashish Mayekar,

    Please refer below links to get answer for your questions:

    1. Database Optimization:

    2. locks for tables:

    Hope it will be helpful to you.

    Ram Prasad

  • #756324
    Thank you for your reply.

    But still I am confuse regarding Locks as documents are not clear.
    Optimization techniques : what I found is Indexing only.

    Is there any rules for optimization while writing Stored procedure , function or cursors??

    Ashish Mayekar

  • Sign In to post your comments