SQL Server Interview Questions
Questions Answers Views Company eMail

What is a join in sql?

781

Why use update_statistics command in sql server?

788

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

725

What are locks in sql?

743

In what sequence sql statement is processed?

803

Explain how many types of relationship?

793

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

760

List the different types of collation sensitivities in sql server?

773

Why use cursor in sql server?

791

Write the syntax for stuff function in an sql server?

770

What does man by sql wildcard characters in sql server?

758

Explain about unique identifier data type in sql server?

712

List all types of constraints in sql server?

721

What are views used for?

810

What are constraints?

790


Un-Answered Questions { SQL Server }

How to add the custom code in Report?

112


How to generate create table script on an existing table in ms sql server?

886


What is self join in sql server joins?

767


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

711


What is index, cluster index and nonclustered index?

717


How to enter comments in transact-sql statements?

750


How to use subqueries with the in operators in ms sql server?

789


Explain view in sql server?

849


What is 5nf in normalization form?

766


What is the sql profiler?

708


What is constraints and its types?

720


How to scale out a federation by Sql statement?

112


What is hot add cpu in sql server 2008?

737


What is a covering index?

754


How many joins in sql server?

723