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


SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

 4 6352

What is a view?

 6 7600

What is an Index?

Yardi Software,

3 8411

What are the types of indexes available with SQL Server?

Standard Bank,

2 6492

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

Infogain,

9 35421

What are cursors?

 8 8866

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 16851

Which TCP/IP port does SQL Server run on?

 2 8990

From where can you change the default port?

 3 5891

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

 15 20350

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

Shriram,

2 9104

What is the use of DBCC commands?

NA,

4 7699

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,

2018

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 3776

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

World Tech, Yardi Software,

11 26241

Un-Answered Questions { SQL Server }

How except clause is differs from not in clause?

521

How to disable triggers using "disable trigger"?

544

What is row-level compre?

533

Explain features and concepts of analysis services?

489

What is sqlservr.exe - process - sql server (sqlex?press)?

583




How do I edit a stored procedure in sql server?

496

What is the difference between deallocate cursor and close cursor?

700

Mention the differences between local and global temporary tables.

550

How much space does sql server 2016 take?

560

What is table-valued sub query?

555

How to verify the port number of the sql server?

543

What are the types of resultset?

517

what protocol both networks use? : Sql server database administration

524

Can you always create a cache of a report?

115

What is the purpose of a table?

504

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