SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is awe?

1012

When columns are added to existing tables, what do they initially contain?

1034

What is the order by used for?

1024

What is a transactions?

1041

What is row_number()?

984

What stored by the master?

952

What is 'write-ahead log' in sql server 2000 ?

1050

What is bcp? When does it used?

976

Which are new data types introduced in sql server 2008?

1049

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1140

What are the basic functions for master, msdb, model, tempdb and resource databases?

987

What is the purpose of the master database?

1129

Does server sql treat char as a variable-length or fixed-length column?

1034

Does sql server 2000 full-text search support clustering?

864

What is filtered index?

1095

Un-Answered Questions { SQL Server }

What is bulkcopy in sql?

943

How to achieve Paging of records in SQL SERVER?

1101

What is tabulation?

951

How can we check the sql server version?

1067

what are the different stages of Report Processing?

135

What is database mirroring?

1117

What are the steps you can take to avoid “deadlocks”?

978

How to copy data from one table to another table?

996

How to test odbc dsn connection settings?

1034

Explain primary key?

966

Call by value and call by reference in procedure and function, with NOCOPY.

1306

how to avoid cursors? : Sql server database administration

969

How can I create a report based on a query? : sql server management studio

1015

Define ACID properties in a Database?

1057

How to convert binary strings into integers in ms sql server?

1029

For More Un-Answered { SQL Server } Questions Click Here