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?

935

Determine when an index is appropriate?

1129

Can you explain important index characteristics?

1031

Explain the purpose of indexes?

1021

Explain full-text indexing?

1042

Do you know clustered and non-clustered index?

1021

Explain the difference between clustered and non-clustered index?

968

Explain having clause and where clause?

1093

Explain indexes disadvantages?

1141

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

1023

Ms sql server index?

1101

Do you know what is fill factor and pad index?

1046

How to maintain a fill factor in existing indexes?

1052

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

1027

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

989

Un-Answered Questions { SQL Server }

What are the different types of backups that exist?

1221

Explain the difference between cross join and full outer join?

1033

Do you know what is sql service broker?

1161

What stored by the msdb?

1046

How to start sql server browser service?

1181

What is ms sql server triggers?

1070

What are the rendering extensions of ssrs?

160

What is data source document?

1089

What are key constraints?

1018

Why Master database is required?

1186

What is indexing and its types?

1056

What is a benefit of using an after insert trigger over using a before insert trigger?

1033

What does the on delete cascade option do?

1062

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1229

How to delete all rows with truncate table statement in ms sql server?

1045

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