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

1059

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

954

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

1128

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

1065

What stored by the tempdb ? : sql server database administration

1098

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

1169

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

1065

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

1231

What is service broker? : sql server database administration

1033

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

1172

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

1175

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

1047

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

1106

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

1024

Un-Answered Questions { SQL Server }

How do you delete duplicate rows in sql server?

1009

how to trace the traffic hitting a sql server? : Sql server database administration

1958

Write a program to fetch first 10 records from a file?

1066

What are the advantages of sql stored procedure?

1128

what is a correlated sub-query? : Sql server database administration

992

What are page splits?

1056

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1058

what's the information that can be stored inside a bit column? : Sql server database administration

1093

Is mysql better than sql server?

1112

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1355

Explain transaction server isolation?

1086

Do you know what is a trace frag? Where do we use it?

1046

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

2001

What does this statement do @@rowcount?

1016

What is the tcp/ip port on which sql server runs?

1246

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