Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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

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