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 scan table/view and seek table/view when its occurs? : sql server database administration

1098

How to truncate the log in sql server 2012? : sql server database administration

1350

What is the difference between lock, block and deadlock? : sql server database administration

1094

Explain the different types of backups available in sql server? : sql server database administration

990

What stored by the master? : sql server database administration

1187

What stored by the msdb? : sql server database administration

1053

What are the joins in sql server? : sql server database administration

1050

Describe the left outer join & right outer join. : sql server database administration

1040

What is data compression? : sql server database administration

1019

What is blocking and how would you troubleshoot it? : sql server database administration

1098

What is sql profiler. What are the default templates with it? : sql server database administration

1111

Where the sql logs gets stored? : sql server database administration

1014

What stored by the model? : sql server database administration

1005

How do you test your database? : sql server database administration

1077

How to view the error log for any specific instance? : sql server database administration

1098

Un-Answered Questions { SQL Server }

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

1245

how many type of indexing in database?

1023

Why do we backup Active Directory ?

1102

How to turn on the mssql api module in php?

1125

How to use old values to define new values in update statements in ms sql server?

1340

Does a server store data?

958

What is the sql server 2000 version number?

1152

how to avoid cursors? : Sql server database administration

1014

What is the contrast between sql and pl/sql?

1201

How do triggers work?

996

tell me the disaster recovery plan

2568

What sql server means?

1009

What is sql language?

1238

Where actually sql azure database is hosted?

167

How to change server name in sql server?

1255

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