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 would rewrite the sql query to return the customerid sorted numerically?

1046

What you can do to delete a table without the delete trigger firing?

1016

What is the difference between insensitive and scroll cursor?

1243

Why transaction is important?

1025

in the physical file layout, where should the transaction log be stored in relation to the data file?

1044

What are the approximate numeric data types?

988

What is a partitioned view?

1055

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1089

What is a derived table?

994

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1257

Will the writetext statement activate a trigger?

1156

Other than truncate statement, which other command can by-pass the trigger on the tables?

1195

Is it important for a database administrator to understand the operating system and file access?

1045

What is the fastest way to permanently delete a 1 million row table named customers?

1339

How do you rebuild an identity column?

999

Un-Answered Questions { SQL Server }

Which is the latest version of sql server and when it is released?

1207

What is the difference between locking and multi-versioning?

1042

What is meant by referential integrity?

1050

if no size is defined while creating the database, what size will the database have? : Sql server administration

1061

What are different types of views?

990

How you trouble shoot when any job fails

1984

What is the process of indexing?

1057

What is precedence constraint?

1039

What are differences in between sql server 2012 and sql server 2016?

1099

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

1041

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2081

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

319

Why we use the openxml clause?

1059

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1134

What is for xml in sql server?

1142

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