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

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1008

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

900

What is sql server management studio? : sql server management studio

1068

How can I create a report based on a query? : sql server management studio

1015

What stored by the tempdb ? : sql server database administration

1040

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1033

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1114

How to find the service pack installed? : sql server database administration

1021

What are recommended options to be used while using db mirroring? : sql server database administration

1147

What is service broker? : sql server database administration

989

How to find the version of sql server? : sql server database administration

1104

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1122

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

985

Where sql server user names and passwords are stored in sql server? : sql server database administration

1046

According to you what goes into making the best database administrator? : sql server database administration

974

Un-Answered Questions { SQL Server }

What is hot add cpu in sql server 2008?

922

How do you run a trace?

893

What is the syntax to execute the sys.dm_db_missing_index_details?

1019

List the advantages of using stored procedures?

1044

How to find related tables in sql server?

932

Can we delete data from a view?

919

Where can you add custom error messages to sql server?

1118

Why I am getting this error when dropping a database in ms sql server?

1072

Explain a checkpoint?

1023

Explain what is analysis service repository?

982

How do I view views in sql server?

1001

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

1249

Can an automatic recovery be initiated by a user?

998

What are the basic features of a trigger in ms sql server?

1184

What are the properties of the relational tables?

874

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