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

What is stretch database in sql server?

1064

How to populate a table in sql server?

962

How many types of local tables are there in sql server?

930

How to get the query of a table in sql server?

898

What are tables in sql server?

1038

What is the maximum size of column in sql server?

892

How to find table changes in sql server?

1119

Where views are stored in sql server?

985

How to find related tables in sql server?

944

How to check if a table is being used in sql server?

962

How to edit table in sql server 2017?

926

What is history table in sql server?

971

Why functions are used in sql server?

960

How to link tables in sql server?

933

What are temporal tables in sql server 2016?

883

Un-Answered Questions { SQL Server }

Why is normalisation important?

942

Mention the uses of stored procedures.

970

What is the downside of using udf?

1109

Do you think BCNF is better than 2NF & 3NF? Why?

1278

What is the difference between push and pull subscription? : sql server replication

1216

What are the steps to process a single select statement?

942

what is the difference between Tabular and Matrix report?

170

What is nested transaction?

1101

What is #table in sql server?

1041

What is the default server name for sql server?

1166

How to receive output values from stored procedures?

1142

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

929

What are the steps you should follow to start sql server in single-user mode?

904

How to use the inserted and deleted pseudo tables?

961

What are the steps you will take to improve the performance of a poor performing query?

979

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