Click here to Skip to main content
Click here to Skip to main content

SQL Server Interview Questions and Answers Complete List Download

By , 17 Jun 2007
Rate this:
Please Sign up or sign in to vote.

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 - Introduction
SQL Server Interview Questions and Answers - Part 1
SQL Server Interview Questions and Answers - Part 2
SQL Server Interview Questions and Answers - Part 3
SQL Server Interview Questions and Answers - Part 4
SQL Server Interview Questions and Answers - Part 5
SQL Server Interview Questions and Answers - Part 6

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.

License

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

About the Author

pinaldave
Founder http://blog.SQLAuthority.com
India India
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2200 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of two SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
Follow on   Twitter

Comments and Discussions

 
QuestionThanks Pinmemberchandr gupt2-Jan-13 19:47 
GeneralMy vote of 5 PinmvpMd. Marufuzzaman8-Sep-11 9:36 
GeneralMessage Automatically Removed PinmemberDotNetGuts4-Sep-07 19:05 
GeneralRe: MORE Collection on SQL Questions Pinmembercdbh4-Sep-07 19:18 
GeneralMessage Automatically Removed PinmemberMember 794027620-May-11 0:58 
GeneralNice questions PinmemberSylvester george27-Jun-07 20:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140415.2 | Last Updated 17 Jun 2007
Article Copyright 2007 by pinaldave
Everything else Copyright © CodeProject, 1999-2014
Terms of Use
Layout: fixed | fluid