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 8607

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

1 2881

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

3 3764




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 2593

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

TCS,

3 6424

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

1 2847

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

Wipro,

10 11368

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

HCL,

1 8154




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

HCL,

1 5617

What is blocking and how would you troubleshoot it?

HCL,

3 4671

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

HCL,

3 7741

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

HCL,

1 6105

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

HCL,

2 6211

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

HCL,

3 11469

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

HCL,

2 7459


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

950


How can we call UDF(User Define Function) using C# code in ASP.net ?

4823


How do use Having,Group by,Group function in SQL?

741


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1331


Explain Capacity planning to create a database? and how to monitor it?

2947






where the connection string store in the database

898


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1418


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

861


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1017


how to overcome kernel isssues

529


Call by value and call by reference in procedure and function, with NOCOPY.

230


Scalability, Availability, Integration with internet, etc.)?

1740


last function used in MS Access to convert sql what function will use in sql

929


what are the Prerequisites for Replication?

8749


SQL Server Architecture ?

1206