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

Is it ok to shrink transaction log?

1004

How do you rename a table in sql server?

1025

What is recompile sql server?

1038

What is tempdb in sql server?

973

What is query optimizer in sql server?

1020

What is the default sql server instance name?

1034

What is the maximum size of a row in sql server?

969

How do you clear a log file?

1048

What is the size of transaction log file?

931

What is the maximum rows in sql server table?

911

What is sleeping status in sql server?

1023

How do I find the sql server instance name?

967

What protocol does sql server use?

943

Is sql server difficult to learn?

920

What is log ldf?

983

Un-Answered Questions { SQL Server }

What is a raid and what are different types of raid configurations?

1267

What is update_statistics command?

1065

What are the types of lock supported by ?

1044

What are the disadvantages of indexes?

1090

What are the different authentication modes in sql server? How can it be changed?

1089

How do you clear a log file?

1048

What is in place upgrade in sql server?

1045

How many cores do I need for sql server 2016?

899

Explain the microsoft sql server delete command?

1019

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

976

Â Explain what is sql override for a source taLle in a mapping?

1012

How to scale out a federation by Sql statement?

116

Define tool Manage Statistics in SQL Server 2000 query ?

1093

What is rs.exe utility?

156

How can we rewrite sub-queries into simple select statements or with joins?

981

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