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 a trigger?

4 8319

What is a view?

6 9418

What is an Index?

Yardi Software,

3 9696

What are the types of indexes available with SQL Server?

Standard Bank,

2 8048

What is the basic difference between clustered and a non-clustered index?

Infogain,

9 38202

What are cursors?

8 11207

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 18897

Which TCP/IP port does SQL Server run on?

2 9983

From where can you change the default port?

3 6990

Can you tell me the difference between DELETE & TRUNCATE commands?

15 25183

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

Shriram,

2 10272

What is the use of DBCC commands?

NA,

4 9318

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

iSoft,

2523

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 4727

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

World Tech, Yardi Software,

11 29664

Un-Answered Questions { SQL Server }

What is change data capture (cdc) in sql server 2008?

1024

Define Wed Edition in SQL Azure?

100

What do you understand by a stored procedure?

1088

Your table has a large character field there are queries that use this field in their search clause what should you do?

886

How can change procedure in sql server?

1066

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

1030

In which format does an image save in SQL Server database ?

1002

Can sub report data source be different from that of the parent report?

143

Explain how dts is used to extract, transform and consolidate data?

998

What are the different types of backups avaialabe in sql server 2005?

1022

explain databases and sql server databases architecture? : Sql server database administration

964

What is the significance of null value and why should we avoid permitting null values?

988

What is enhanced database mirroring in sql server 2008?

971

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

982

Explain the purpose of indexes?

977

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