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?

1051

How do you rename a table in sql server?

1098

What is recompile sql server?

1079

What is tempdb in sql server?

1026

What is query optimizer in sql server?

1070

What is the default sql server instance name?

1084

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

1004

How do you clear a log file?

1108

What is the size of transaction log file?

984

What is the maximum rows in sql server table?

961

What is sleeping status in sql server?

1073

How do I find the sql server instance name?

1012

What protocol does sql server use?

985

Is sql server difficult to learn?

966

What is log ldf?

1042

Un-Answered Questions { SQL Server }

What are acid properties of transaction?

995

What is the difference between DATETIME2 and DATETIME?

1124

Can we use trigger new in before insert?

958

Explain mixed authentication mode of sql server?

1115

Why we use the openxml clause?

1054

Does group by sort data?

945

What is sub query and its properties?

1024

What is the difference between truncate and delete commands?

1107

What are different types of subquery?

1302

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3919

Can we update data in a view?

1076

Give me any three differences between Truncate and Delete.

1154

How to make remote connection in database?

1047

What will be the maximum number of index per table?

1055

Explain collation?

1100

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