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 8307

What is a view?

6 9412

What is an Index?

Yardi Software,

3 9696

What are the types of indexes available with SQL Server?

Standard Bank,

2 8044

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

Infogain,

9 38196

What are cursors?

8 11201

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 18888

Which TCP/IP port does SQL Server run on?

2 9980

From where can you change the default port?

3 6987

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

15 25158

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

Shriram,

2 10269

What is the use of DBCC commands?

NA,

4 9311

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,

2521

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 4723

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

World Tech, Yardi Software,

11 29651

Un-Answered Questions { SQL Server }

What are the disadvantages of merge replication?

1421

What will be the maximum number of index per table?

1002

What stored by the tempdb ? : sql server database administration

1045

Can a table be moved to different filegroup?

976

Mention the differences between substr and charindex in sql server.

1050

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2241

How to create stored procedures with parameters in ms sql server?

1079

How do I save a stored procedure in sql server?

996

How to delete existing rows in a table?

1158

What is difference between sql and sql server?

999

List the various tools available for performance tuning?

887

How to get the definition of a user defined function back?

1044

What does set rowcount do?

909

What are subqueries in sql server?

1120

What is a non equi join?

981

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