SQL Server Interview Questions
Questions Answers Views Company eMail

What do we need queues in sql service broker?

514

Define self join in sql server joins?

506

What is importing utility?

536

Define model database?

564

Define outer join?

522

Explain the different types of joins?

554

How except clause is differs from not in clause?

521

Define outer join in sql server joins?

511

What is sql server english query?

526

Explain the difference between cross join and full outer join?

482

Explain different forms of normalization?

517

Explain the disadvantages/limitation of the cursor?

548

What are different types of raid levels?

536

What is hot add cpu in sql server 2008?

508

Define cross join in sql server joins?

576


Un-Answered Questions { SQL Server }

What is a trigger and its types?

520


Where sql server user names and passwords are stored in sql server? : sql server database administration

565


How to create and drop temp table in sql server?

575


How many types of keys are there?

518


Can two tables share a primary key?

501






Explain the difference between primary keys and foreign keys?

496


Explain datetime2 data type in sal server 2008?

538


explain different types of constraints? : Sql server database administration

502


How do I get Report Builder to generate a parameter that can be set by users viewing the report?

100


What is raid, and how it can influence database performance?

560


what is nonclustered index

531


How do you clear a log file?

497


How to return the top 5 rows from a select query in ms sql server?

575


How to receive output values from stored procedures?

467


What are transactions and its controls?

602