What is Database Mirroring ?

Mirroring is creating an additional instance of a SQL Server, thereby increasing availability. The source instance is called Principal Server and the target instance is called the Mirrored server.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is the work of the DTC ?

The DTC manages the committing of transactions when there are several different data sources involved.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is the expansion of DTC ?

Distributed Transaction Coordinator .

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #73 - SQL Performance Tuning

"SET NOCOUNT ON" reduces network traffic between server and client.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #72 - SQL Performance Tuning

use the SQL Server's Profiler Create Trace Wizard to run the "Profile the Performance of a Stored Procedure" trace to provide you with the data you need to identify poorly performing stored procedures..

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is a Linked Server ?

It is an alias on the local SQL Server which points to an external data source.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #71 - SQL Performance Tuning

Use covering index whereever needed, it reduces logical and physical IO and increases performance.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning