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 to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 11819

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 4599

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 6773

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 4326

What is the system function to get the current user's user id?

TCS,

3 9674

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 4697

What's the difference between a primary key and a unique key?

Wipro,

10 18747

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

HCL,

1 10363

What are the steps you will take, if you are tasked with securing an SQL Server?

HCL,

1 7967

What is blocking and how would you troubleshoot it?

HCL,

3 8234

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

HCL,

3 11413

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

HCL,

1 8572

What are statistics, under what circumstances they go out of date, how do you update them?

HCL,

2 9145

What are the different ways of moving data/databases between servers and databases in SQL Server?

HCL,

3 15220

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

HCL,

2 10719

Un-Answered Questions { SQL Server }

How can you append an identity column to a temporary table?

1050

How do I start sql server 2017?

1000

How do I create a trace in sql server?

1102

Why should you use or avoid select * statements?

1094

How can we solve concurrency problems?

1110

What is self contained sub query?

1129

Does view occupy space?

998

How raid can influence database performance?

1093

What is the difference between upgrade and migration in sql server?

1163

What is in place upgrade in sql server?

1113

How can I check that whether automatic statistic update is enabled or not?

1101

What is normalization and what are the advantages of it?

1042

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1034

Explain system functions or built-in functions? What are different types of system functions?

1052

What are the properties of the transaction?

1059

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