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

1011

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

996

how can a database be repaired? : Sql server administration

1018

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

1050

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

1316

what does the automatic recovery do? : Sql server administration

1082

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

1122

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

1044

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

1002

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

1041

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

1027

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

1061

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

1057

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

1017

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

1030

Un-Answered Questions { SQL Server }

Explain why variables called the most powerful component of ssis?

1178

How you can minimize the deadlock situation?

1089

How to provide values to user defined function parameters?

1064

What is the correct order of the logical query processing phases?

997

Define tempdb database?

1043

Explain four layers of abstraction microsoft architectured?

147

How can we delete a table in sql server?

1024

Can you explain full-text query in sql server?

1061

If the job running very slow what is the action you do

1945

How network traffic be reduced by using the stored procedure?

1179

How to achieve Paging of records in SQL SERVER?

1151

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

1078

Define right outer join?

1017

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1018

Detail about the hardware which is supported by SQL server?

1124

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