SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

4 4085

What is a view?

6 5024

What is an Index?

Yardi Software,

3 5699




What are the types of indexes available with SQL Server?

Standard Bank,

2 5037

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

9 31053

What are cursors?

8 5397

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 14268

Which TCP/IP port does SQL Server run on?

2 7626




From where can you change the default port?

3 4384

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

15 14931

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

Shriram,

2 6929

What is the use of DBCC commands?

4 5671

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,

1351

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 2524

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

Yardi Software, World Tech,

11 20756


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

your distribution database is full what will u do

956


Why do you want to join software field as you have done your BE in Electronics?

1023


How do you Implement SSIS Packages in your Project?

834


which backup strategy you are following at ur company

992


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1256






how to take backup bcp out for a column in table in sql server?

854


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

940


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

863


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

808


How to convert a table data in XML format in sql server?

1399


System variable and temporary variables

979


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

809


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2676


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

936


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

864