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?

1060

How do you rename a table in sql server?

1104

What is recompile sql server?

1087

What is tempdb in sql server?

1031

What is query optimizer in sql server?

1077

What is the default sql server instance name?

1093

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

1010

How do you clear a log file?

1115

What is the size of transaction log file?

989

What is the maximum rows in sql server table?

964

What is sleeping status in sql server?

1080

How do I find the sql server instance name?

1018

What protocol does sql server use?

990

Is sql server difficult to learn?

968

What is log ldf?

1048

Un-Answered Questions { SQL Server }

What are the disadvantages of indexes?

1163

How to use transact-sql statements to access the database engine?

1127

How do you troubleshoot errors in a SQL Server Agent Job?

1113

What is the difference between varchar and varchar types?

1124

what are database files and filegroups? : Sql server database administration

1000

In what sequence sql statement is processed?

1057

How to insert stored procedure result into temporary table?

1068

What are magic tables in sql server?

1204

What is ms sql server reporting services?

1128

What is the web service used for reporting services?

126

How you can add messages to the nt event log from within a stored procedure?

1143

How to verify a user name with sqlcmd tool?

1122

What is dimension table? : sql server analysis services, ssas

1066

Explain how to integrate the ssrs reports in application?

1065

How to stop log file growing too big?

1066

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