SQL Server Interview Questions
Questions Answers Views Company eMail

What is log shipping?

556

What are the properties of the transactions?

606

What is cursors? And what are the different types of cursor?

549

What is database white box testing?

664

What are the properties of sub-query?

572

What’s the distinction between dropping a info and taking a info offline?

590

Explain the working of sql privileges?

599

What are indexes in sql?

569

What are the system database in sql server 2005?

545

Define clusters?

641

How we can refresh the view?

585

What is the difference between set and select?

565

What is the difference between stored procedure and user defined functions?

613

What area unit the various kinds of info compression introduced in sql server 2008?

561

What is the contrast between sql and mysql?

584


Un-Answered Questions { SQL Server }

What is the difference between push and pull subscription? : sql server replication

603


What are the properties of sub-query?

572


How can I get data from a database on another server?

503


What are the purpose of Normalisation?

632


Is it ok to shrink transaction log?

507






how to use DTS package in 2000,2005,2008 in sql server

1445


What is dbcc? Give few examples.

564


What is lock escalation? : sql server database administration

589


Differentiate between mongodb vs. Sql server?

568


What are sp_configure commands and set commands?

553


How to sort query output in descending order in ms sql server?

531


What is a trace frag?

630


How to update multiple rows with one update statement in ms sql server?

627


Explain error handling in ssis?

560


Why use update_statistics command in sql server?

544