1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 10169

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

 1 3720

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

 3 5359

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 3575

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

TCS,

3 8291

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

 1 3844

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

Wipro,

10 15441

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

HCL,

1 9557

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

HCL,

1 6900

What is blocking and how would you troubleshoot it?

HCL,

3 6669

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

HCL,

3 9822

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

HCL,

1 7587

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

HCL,

2 7995

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

HCL,

3 13677

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

HCL,

2 9221

Un-Answered Questions { SQL Server }

How to create new table with "create table" statements?

560

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

504

What is report snapshot?

99

Describe in brief sql server monitoring ways.

587

Do you know what are the restrictions that views have to follow?

624




How to enter binary string literals in ms sql server?

582

How can you manage sql azure security?

85

What are different types of database indexes?

525

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

698

What is auditing in sql server?

501

What is the template in sql?

539

Where are stored procedures in sql server?

564

Who developed sql server?

530

How to verify a login name with sqlcmd tool?

592

What are the differences between union, intersect, and minus operators?

574

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