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?

940

Determine when an index is appropriate?

1137

Can you explain important index characteristics?

1033

Explain the purpose of indexes?

1027

Explain full-text indexing?

1045

Do you know clustered and non-clustered index?

1025

Explain the difference between clustered and non-clustered index?

971

Explain having clause and where clause?

1103

Explain indexes disadvantages?

1151

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

1028

Ms sql server index?

1105

Do you know what is fill factor and pad index?

1047

How to maintain a fill factor in existing indexes?

1060

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

1031

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

994

Un-Answered Questions { SQL Server }

What are different types of raid configurations? : SQL Server Architecture

1138

Can truncate be rolled back?

996

What is use of dbcc commands?

1126

What is thr feature of change data capture?

1039

What is the default order of an order by clause?

1040

What methods do you follow to protect from sql injection attack?

1075

How to create a dynamic cursor with the dynamic option?

1111

What is filter index?

995

Is it possible for a stored procedure to call itself or recursive stored procedure?

1008

What is collation sensitivity? Explain different types.

1058

What are security principals used in sql server 2005?

1041

Explain what is lock escalation?

1113

What are trace flags and mention a few common trace flags used with sql server?

1144

what protocol both networks use? : Sql server database administration

1021

How except clause is differs from not in clause?

1013

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