SQL Server Interview Questions
Questions Answers Views Company eMail

Define master database?

556

Explain transaction server auto commit?

517

What are the essential components of sql server service broker?

534

Why do we use non clustered index?

537

How to use the inserted and deleted pseudo tables?

521

Define full outer join?

500

Explain concepts of analysis services?

488

Explain where clause?

515

What are the advantages of sql stored procedure?

514

Explain syntax for disabling triggers?

500

Define left outer join?

553

How dts is used to extract, transform and consolidate data?

572

How to implement service broker?

502

What is fill factor and pad index?

514

What are constraints in microsoft sql server?

538


Un-Answered Questions { SQL Server }

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

1555


What are the types of sql server?

497


What is the sql case statement used for?

539


How much is a sql server license?

478


what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

627






Can you tell me some of the common replication dmv's and their use? : sql server replication

519


What are window functions in sql server?

485


Does partitioning ssd reduce performance?

469


Can we insert data into view sql server?

492


What are the essential components of sql server service broker?

534


how will add additional conditions in sql?

554


How do you create an execution plan?

475


what is raid and what are different types of raid configurations? : Sql server database administration

513


What is bookmark link in ssrs?

108


How do you delete a data source?

514