Question.1 Explain about your SQL Server DBA Experience? Answer: This is a generic question often asked by many interviewers. Explain what are the different SQL Server Versions you have worked on, what kind of administration of those instances has been done by you. Your role and responsibilities carried out in..
Question.1 Which TCP/IP port does SQL Server run on? How can it be changed? Answer: SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties. Question.2 What are the difference between clustered and a non-clustered index? Answer: A clustered index is a special type..