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 oracle faster than sql server?

953

What is sql server database?

1009

What is the difference between mysql and sql server?

1024

How do I trace a query in sql server?

952

What is sql server transaction log file?

1054

How do I run a trace in sql server?

983

What is the use of sql profiler in sql server 2012?

897

Which trace flags are enabled in sql server?

1014

What is dbcc command in sql server?

1091

How do I find the size of a sql server database?

928

What is query cost in sql server?

995

Why is sql server log file full?

1034

How do I find the query plan in sql server?

957

What is resource db in sql server?

1024

What is spid in sql server profiler?

1105

Un-Answered Questions { SQL Server }

What is the difference function and stored procedure?

1055

What happens if we shrink log file in sql server?

983

What is a group function explain with an example?

988

What are the recovery models for a database?

1103

What are the new scripting capabilities of ssms? : sql server management studio

1067

how would you troubleshoot blocking? : Sql server database administration

980

Differentiate between SQL and ORACLE joins and write their syntax.

1033

Differentiate between mongodb vs. Sql server?

1095

What are the differences between stored procedure and view in sql server?

1246

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4384

Explain how dts is used to extract, transform and consolidate data?

998

How to reaname table name without using sp_Rename in sql server..?

996

How to find index size for each index on table?

1003

Write an sql query for deleting duplicate rows?

995

What is database architecture? : SQL Server Architecture

1044

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