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 you can move data or databases between servers and databases in sql server? : Sql server administration

1026

can a table be moved to different filegroup? : Sql server administration

1016

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1131

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1297

What is the difference between a fill factor of 100 and 0?

1027

A trigger can reference objects outside the current database? State true or false.

1060

How can you list all the table constraints in a database?

980

explain extended properties

1036

What are the results of running this script?

974

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1047

How can you stop stored procedures from recompiling?

946

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1034

What is a livelock?

1012

What are alternate keys?

1027

What does it mean to normalize a database and why would you do it?

1020

Un-Answered Questions { SQL Server }

What is snapshot parameter in ssrs?

155

What is amo? : sql server analysis services, ssas

1133

What are page splits? : SQL Server Architecture

1037

What are the tables in sql?

1145

What are “lost updates”?

1042

How to connect Azure federated root database and apply federation in entity framework?

109

What is the most common trace flags used with sql server?

1114

What is scalar user-defined function?

1185

How can I check that whether automatic statistic update is enabled or not?

1091

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1190

How to stop log file growing too big?

1059

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1085

What is federation member?

116

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

1134

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

1257

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