SQL Server Interview Questions
Questions Answers Views Company eMail

What is a join in sql?

802

Why use update_statistics command in sql server?

809

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

743

What are locks in sql?

764

In what sequence sql statement is processed?

828

Explain how many types of relationship?

816

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

781

List the different types of collation sensitivities in sql server?

788

Why use cursor in sql server?

818

Write the syntax for stuff function in an sql server?

797

What does man by sql wildcard characters in sql server?

777

Explain about unique identifier data type in sql server?

719

List all types of constraints in sql server?

744

What are views used for?

828

What are constraints?

805


Un-Answered Questions { SQL Server }

How to use "begin ... End" statement structures in ms sql server?

750


Tell me what is difference between clustered and non clustered index?

766


what is normalization? Explain different levels of normalization? : Sql server database administration

973


What are the different types of normalization?

891


Can you always create a cache of a report?

145


Can we use having clause without group by?

787


What are triggers? How do you invoke a trigger on demand?

1050


Explain about extended stored procedure?

737


Can group functions be mixed with non-group selection fields in ms sql server?

757


What is checkpoint in sql server?

885


What is difference between index and primary key?

883


What are the disadvantages of indexes?

764


What are functions in the sql server?

876


What are sub reports?

172


Do you know what is a trace frag? Where do we use it?

776