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 7478

What is a view?

 6 8583

What is an Index?

Yardi Software,

3 9124

What are the types of indexes available with SQL Server?

Standard Bank,

2 7354

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

Infogain,

9 36740

What are cursors?

 8 10007

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 17913

Which TCP/IP port does SQL Server run on?

 2 9496

From where can you change the default port?

 3 6420

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

 15 22665

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

Shriram,

2 9678

What is the use of DBCC commands?

NA,

4 8511

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,

2281

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 4303

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

World Tech, Yardi Software,

11 27967

Un-Answered Questions { SQL Server }

What is the difference between NOROW and LOCKROW?

2537

How many database files are there in sql server 2000?what are they?

812

What is the difference between dataadapter and datareader?

780

How to rename an existing column with sql server management studio?

723

How to create a dml trigger using create trigger statements?

782

What is sql or structured query language?

926

How to add code to the existing article (using improve article)?

860

What is Lock table in SQL?

1243

What is cursors?

860

What is normalization of database? What are its benefits?

746

What is plan freezing?

755

What are entities and relationships?

771

What are window functions in sql server?

734

What are the types of resultset?

757

Does partitioning improve performance?

767

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