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?

1033

How do I schedule a sql server profiler trace?

970

What happens if we shrink log file in sql server?

977

How do I create an extended event in sql server?

947

What is trace flag in sql server?

1016

What are extended events in sql server?

948

What is resource governor in sql server?

989

Is foreign key unique?

990

Is foreign key a primary key?

1076

What are rows and columns?

1017

What are the steps to insert a table?

943

Can primary key be null?

926

What are some examples of schemas?

968

How many types of schemas are there?

1038

How do you identify a foreign key?

1021

Un-Answered Questions { SQL Server }

What are parameterized reports?

200

Explain the steps to use transact-sql cursor?

1051

Does sql server 2000 full-text search support clustering?

858

What are the differences between user defined functions and stored procedures?

1063

What is difference between global temporary tables and local temporary tables?

1229

How do I edit a stored procedure in sql server?

919

Define views.

1003

Equi join and non equi join is possible with sql server?

1012

What types of replication are supported in sql server?

1058

how you can configure a running aggregate in SSRS?

190

How do I find the transaction log size in sql server?

952

Do you know sql server 2008 introduces automatic auditing?

974

How to connect to a sql server using odbc_connect()?

1142

What is BCP? When does it used in sql server 2012?

1052

What are distinctive joins find as a part of sql?

949

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