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 11790

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

1 4589

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

3 6748

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 4318

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

TCS,

3 9655

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

1 4690

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

Wipro,

10 18679

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

HCL,

1 10347

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

HCL,

1 7960

What is blocking and how would you troubleshoot it?

HCL,

3 8210

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

HCL,

3 11391

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

HCL,

1 8554

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

HCL,

2 9131

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

HCL,

3 15192

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

HCL,

2 10711

Un-Answered Questions { SQL Server }

How to name query output columns in ms sql server?

1020

How to test odbc dsn connection settings?

1096

How extra digits are handled with numeric data type literals?

1036

Write a program using SQL queries to find a unique entry in a table.

1057

What are sparse columns?

1070

What is the maximum size of column in sql server?

948

Explain hostprotectionattribute in sql server 2005?

1075

How check triggers in sql server?

1058

What is a primary index?

980

How to create a ddl trigger using "create trigger" statements?

1191

What are different types of raid configurations? : SQL Server Architecture

1141

What languages bi uses to achieve the goal?

1054

Can I use sql azure as a backup with log shipping or database mirroring?

156

Why is replication required on the sql server?

1109

What is sharding?

116

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