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 11633

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

1 4505

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

3 6625

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 4226

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

TCS,

3 9518

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

1 4594

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

Wipro,

10 18347

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

HCL,

1 10249

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

HCL,

1 7863

What is blocking and how would you troubleshoot it?

HCL,

3 8067

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

HCL,

3 11225

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

HCL,

1 8450

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

HCL,

2 9009

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

HCL,

3 15065

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

HCL,

2 10593

Un-Answered Questions { SQL Server }

Explain the commands in sql server?

1038

What is a non-clustered index?

998

How does clustered and non clustered index work?

923

What is the process of indexing?

1008

How to drop an existing table?

1001

What is replace and stuff function in sql server?

1065

Is null in sql server?

988

Define cross join in sql server joins?

1021

What is the difference RDBMS and Graph Database?

1047

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

974

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1025

What are the differences between web role and worker role?

122

How to create dbo table in sql server?

950

what are isolation levels? : Sql server database administration

991

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

881

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