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

1055

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

950

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

1122

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

1061

What stored by the tempdb ? : sql server database administration

1096

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

1089

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

1165

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

1062

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

1221

What is service broker? : sql server database administration

1029

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

1162

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

1171

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

1046

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

1102

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

1022

Un-Answered Questions { SQL Server }

How to create new tables with "select ... Into" statements in ms sql server?

1046

How to generate create function script on an existing function?

1177

What is similarity and difference between truncate and delete in sql?

1151

Explain an incremental backup?

1049

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1072

What is the full meaning of dml?

998

What is the difference between mysql and mysqli?

1284

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1991

What is subquery in sql?

1126

What are the transaction properties?

1067

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1040

Explain stored procedure?

1108

How to create user defined functions with parameters?

1293

What do you mean by subquery?

1145

Define msdb database?

1076

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