SQL Server Interview Questions and Answers Complete List Download

Introduction

SQL Server interview questions and answers were original published in six series. This complete series is combined in one article which is listed here in this article. This article is PDF which is available to download for free.

Interview Questions and Answer PDF contains questions from beginner to advance users.

Visit complete series as well as final link to download the PDF.

Points of Interest

SQL Server Interview Questions and Answers Complete List Download

Few Samples Questions

When is the use of UPDATE_STATISTICS command?
This command is basically used when a large processing of data has occurred. If a large amount of deletions any modification or Bulk Copy into the tables has occurred, it has to update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.

Which TCP/IP port does SQL Server run on? How can it be changed?
SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties –> Port number.both on client and the server.

What is Identity?
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but most DBA leave these at 1. A GUID column also generates numbers, the value of this cannot be controled. Identity/GUID columns do not need to be indexed.

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)