SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

4 7401

What is a view?

6 8541

What is an Index?

Yardi Software,

3 9082

What are the types of indexes available with SQL Server?

Standard Bank,

2 7286

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

Infogain,

9 36657

What are cursors?

8 9917

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 17831

Which TCP/IP port does SQL Server run on?

2 9460

From where can you change the default port?

3 6368

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

15 22453

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

Shriram,

2 9635

What is the use of DBCC commands?

NA,

4 8441

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,

2263

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 4264

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

World Tech, Yardi Software,

11 27828


Un-Answered Questions { SQL Server }

How to create a local temporary stored procedure?

740


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1771


Do you know what is sql injection?

748


Is it true that rules do not apply to data already existing in a database at the time the rule is created?

781


What happens to a statement batch if there is a compilation error?

720


What are partitioned views?

766


What is the difference between char, varchar and nvarchar?

787


How to create user messages with print statements in ms sql server?

793


Write a SQL query to make a column as unique?

803


How to set database to be single_user in ms sql server?

812


Explain system views?

824


How do you manipulate data?

688


List the different index configurations possible for a table?

702


How do you trace the traffic hitting a sql server?

843


When multiple after triggers are attached to sql table, how to control the order of execution?

793