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 10004

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

 1 3634

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

 3 5201

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 3490

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

TCS,

3 8097

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

 1 3741

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

Wipro,

10 15022

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

HCL,

1 9437

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

HCL,

1 6781

What is blocking and how would you troubleshoot it?

HCL,

3 6477

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

HCL,

3 9614

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

HCL,

1 7355

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

HCL,

2 7837

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

HCL,

3 13457

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

HCL,

2 9006

Un-Answered Questions { SQL Server }

How to create a simple user defined function in ms sql server?

476

How to generate create function script on an existing function?

526

What are the options which must be set to allow the usage of optimistic models?

454

Can you please explain the difference between primary keys and foreign keys?

557

How many full-text indexes can a table have?

478




How do I manually uninstall an instance of sql server 2016?

478

How to insert stored procedure result into temporary table?

515

How to verify the port number of the sql server?

494

Explain the purpose of indexes?

480

How to create sub reports?

186

What method is used by the Command classes to execute SQL statements that return single values?

536

Which one is faster delete/truncate? Why?

539

How to insert new line characters into strings?

500

What are sub reports?

145

In how many ways you can invoke ssrs reports?

97

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