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

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

1008

can an automatic recovery be initiated by a user? : Sql server administration

991

how can a database be repaired? : Sql server administration

1016

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

1045

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1305

what does the automatic recovery do? : Sql server administration

1077

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

1116

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

1034

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

997

how can you check the level of fragmentation on a table? : Sql server administration

1036

what stored procedure would you use to view lock information? : Sql server administration

1019

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

1059

what stored procedure can you use to display the current processes? : Sql server administration

1053

what information is maintained within the msdb database? : Sql server administration

1012

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1027

Un-Answered Questions { SQL Server }

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

1162

what is a sub-report?

146

What is a join in sql?

1152

Explain how to use linked server?

1031

What are the difficulties faced in cube development? : sql server analysis services, ssas

1096

Explain primary key and foreign key constraints?

1089

Explain a join?

1121

How to loop through the result set with @@fetch_status?

1429

Differentiate sql server reporting services vs. Crystal reports?

209

Does sql server 2000 clustering support load balancing?

1023

how you can move data or databases between servers and databases in sql server? : Sql server administration

1026

how would you improve etl (extract, transform, load) throughput?

1071

How to configure odbc dsn with different port numbers?

1151

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1023

What does set rowcount do?

958

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