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

How do you set a trace flag in sql server?

1086

How do I schedule a sql server profiler trace?

1026

What happens if we shrink log file in sql server?

1029

How do I create an extended event in sql server?

1001

What is trace flag in sql server?

1078

What are extended events in sql server?

1002

What is resource governor in sql server?

1046

Is foreign key unique?

1045

Is foreign key a primary key?

1171

What are rows and columns?

1062

What are the steps to insert a table?

989

Can primary key be null?

978

What are some examples of schemas?

1019

How many types of schemas are there?

1091

How do you identify a foreign key?

1080

Un-Answered Questions { SQL Server }

What are triggers in ms sql server?

1224

Which tcl commands are available on the sql server?

1135

Do you know what are the ways available in sql server to execute sql statements?

1079

What are the dis_advantages of stored procedures, triggers, indexes?

2273

What is correlated subquery in sql server?

1120

How do I port a number to sql server?

1090

whats the maximum size of view state??

2248

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1255

How can I get data from a database on another server?

1041

Explain about temporary stored procedure?

1091

What is the use of toad or sqldbx.?

1199

What is conditional split?

1135

What is a View ? Can we insert, Update and delete a view?

1059

Define ACID properties in a Database?

1102

Mention the differences between sql server and mysql.

1075

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