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 11500

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

1 4426

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

3 6500

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 4153

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

TCS,

3 9365

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

1 4522

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

Wipro,

10 18034

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

HCL,

1 10164

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

HCL,

1 7780

What is blocking and how would you troubleshoot it?

HCL,

3 7928

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

HCL,

3 11089

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

HCL,

1 8372

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

HCL,

2 8915

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

HCL,

3 14922

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

HCL,

2 10495

Un-Answered Questions { SQL Server }

What is the difference between a local and a global temporary table?

1072

What is the difference between char and varchar2 datatype in sql?

1023

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1005

What are dml triggers and types of dml triggers?

930

How to choose all records from the table?

1014

what are the different types of replication you can set up in sql server? : Sql server database administration

983

How many types of subqueries are there in sql server?

947

Explain how many normalization forms?

985

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

942

What is change data capture (cdc) in sql server 2008?

990

How to declare and use cursor variables?

1090

When to use Inner join & when to use subquery?

1099

Difference between primary key and clustered index?

948

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

914

What is collation sensitivity? Explain different types.

970

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