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 11614

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

1 4499

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

3 6603

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 4205

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

TCS,

3 9494

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

1 4582

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

Wipro,

10 18315

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

HCL,

1 10238

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

HCL,

1 7853

What is blocking and how would you troubleshoot it?

HCL,

3 8044

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

HCL,

3 11206

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

HCL,

1 8442

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

HCL,

2 8990

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

HCL,

3 15050

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

HCL,

2 10581

Un-Answered Questions { SQL Server }

How to execute the cursor queries with "open" statements?

1175

New concepts of sql server 2005 use in your project.

2355

Why people hate cursor?

1138

How to achieve Paging of records in SQL SERVER?

1093

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1212

What is a virtual table in sql?

987

Explain how you can configure a running aggregate in SSRS?

163

What is temporal table?

879

explain different types of constraints? : Sql server database administration

949

Why we use functions in sql server?

1064

How to update muliple row in single query?

1048

How to convert numeric expression data types using the cast() function?

1057

How do I view a stored procedure in sql server?

977

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

878

What are the advantages of having an index on the sql server?

922

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