What is the expansion of SARG ?

Search ARGument.

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

What is the advantage of UNION ALL over UNION with respect to performance?

The advantage of the UNION ALL is that is does not perform the SELECT DISTINCT function where the UNION does.

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

Daily Tips- Tip #69 - SQL Performance Tuning

To help identify long running queries, use the SQL Server Profiler Create Trace Wizard to run the "TSQL By Duration" trace.

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

Daily Tips- Tip #68 - SQL Performance Tuning

Avoid using temp table unnecessarily, if needed explicity create them.

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

Daily Tips- Tip #67 - SQL Performance Tuning

Use set nocount on at the top of each stored procedure and set nocount off at the bottom.

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

Daily Tips- Tip #66 - SQL Performance Tuning

Create an index on any column that is a foreign key.

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

Daily Tips- Tip #65 - SQL Performance Tuning

Create a primary key on each table you create and unless you are really knowledgeable enough to figure out a better plan, make it the clustered index.

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