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


SQL Server Interview Questions
Questions Answers Views Company eMail

What is a join in sql?

 574

Why use update_statistics command in sql server?

 540

List out the difference between union and union all in sql server?

 508

What are locks in sql?

 526

In what sequence sql statement is processed?

 573

Explain how many types of relationship?

 564

What is de-normalization in sql database administration? Give examples?

 525

List the different types of collation sensitivities in sql server?

 516

Why use cursor in sql server?

 534

Write the syntax for stuff function in an sql server?

 521

What does man by sql wildcard characters in sql server?

 507

Explain about unique identifier data type in sql server?

 494

List all types of constraints in sql server?

 505

What are views used for?

 608

What are constraints?

 573

Un-Answered Questions { SQL Server }

Explain data warehousing in sql server?

591

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

597

What is meant by referential integrity?

576

What is the difference between commit and rollback?

488

Where is localdb stored?

539




How do you clear a log file?

497

how you can configure a running aggregate in SSRS?

112

How do I determine how many instances of sql server are installed on a computer?

521

What is nonclustered index on computed columns?

563

What is store procedure? How do they work?

565

What are the system database in sql server 2008?

566

What does the update command do?

601

Explain the various types of concurrency problem?

687

How to rebuild master databse?

647

What are triggers in ms sql server?

593

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