SQL Server Interview Questions
Questions Answers Views Company eMail

Why the trigger fires multiple times in single login?

725

How to optimize stored procedure optimization?

519

What is use of except clause?

631

What is an execution plan? When would you use it?

580

What are “lock” hints?

593

Explain ranking functions?

610

How many clustered indexes there can be on table ?

602

What is user-defined multi-statement table-valued function?

657

Why de-normalization required?

576

What is co-related sub query?

567

Explain trigger and trigger types?

558

Which are the new data types introduced in sql server 2008?

514

How we can compare two database data?

521

Explain aggregate functions?

562

What is self contained multi valued query?

560


Un-Answered Questions { SQL Server }

What is unpivot?

572


How is a full-text index updated?

541


What is index in an assignment?

534


How to use old values to define new values in update statements in ms sql server?

684


Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

581






How to count rows with the count(*) function in ms sql server?

538


Explain about builtinadministrator?

597


What is the chart in report?

111


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

590


how you can get the list of largest tables in a database? : Sql server administration

553


what is datawarehouse?

651


Write a sql query to display the current date?

638


how to avoid cursors? : Sql server database administration

493


What are the different types of sql server replication? : sql server replication

625


Why use “pivot” in sql server?

629