SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is update locks?

886

Determine when an index is appropriate?

1076

Can you explain important index characteristics?

991

Explain the purpose of indexes?

976

Explain full-text indexing?

980

Do you know clustered and non-clustered index?

979

Explain the difference between clustered and non-clustered index?

923

Explain having clause and where clause?

1055

Explain indexes disadvantages?

1083

Explain what is it unwise to create wide clustered index keys?

977

Ms sql server index?

1062

Do you know what is fill factor and pad index?

1004

How to maintain a fill factor in existing indexes?

1006

Write down the syntax and an example for create, rename and delete index?

982

Tell me the difference between clustered and non-clustered index?

937

Un-Answered Questions { SQL Server }

What is raiseerror? What is raiseerror?

1141

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1062

what is denormalization and when would you go for it? : Sql server database administration

1183

Can you explain what are commit and rollback in sql?

940

What are the difference between “where” and “having” clause in sql server?

1069

How and why use sql server?

1007

How to return the date part only from a sql server datetime datatype?

1103

What is a periodical index?

926

What command is used to create a database in the sql server and how?

1177

What is a trace frag? Where do we use it?

1100

Define tempdb database?

994

How except clause is differs from not in clause?

953

How to sort query output in descending order in ms sql server?

942

How do you make a trace?

1024

What is the function of inner join?

1072

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