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

How many triggers are possible per table?

1140

What is the maximum number of index per table?

1117

How to recompile stored procedure at run time?

1117

What are the different types of stored procedures?

1155

What is difference between rollback immediate and with no_wait during alter database?

1133

What is merge statement?

1133

Explain throw statement in sql server 2008?

1054

What is nonclustered index on computed columns?

998

Explain some stored procedure creating best practices or guidelines?

1002

Explain try...catch with sql server?

1072

What are sp_configure commands and set commands?

1075

What is the ‘fillfactor’?

1014

What is read uncmmited?

1115

What is an sql server agent?

1112

What is the difference between for trigger and after trigger?

1158

Un-Answered Questions { SQL Server }

List all the types of user-defined functions?

1182

What is advantage data architect?

976

What is single-user mode?

981

What is database architecture? : SQL Server Architecture

1099

Why do we use trigger?

1024

Why should we go for stored procedures? Why not direct queries?

1157

Who developed sql server?

982

Why does sql studio use a single registered database repository? : sql server management studio

1037

What part does database design plays a role in performance of an sql server-based application?

1033

Explain indexed views and partitioned view with their syntax.

1193

What is the purpose of data source?

1089

What is a fan-out query in SQL Azure?

123

What are character string data types in ms sql server?

1347

When you use @@error and try-catch?

1091

What is normalization of database? What are its benefits?

1070

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