Why?

Do you want to see a query that uses an index seek or do you want the most efficient query...

Please post results of this query for the table in question

select index_id, index_type_desc, avg_fragmentation_in_percent, page_count

from sys.dm_db_index_physical_stats(db_id(), object_id('Table Name'),null, null, 'limited')

Look up DATEADD in SQL's Books Online.

If you want to default to yesterday at midnight, then check this blog post out.

http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/

Please post the execution plan of the query in question, both where there are multiple single-column indexes and where there's one composite index.

I don't see any query in your posted...

spatnaik77 (10/2/2009)

---

SELECT AGE FROM CUSTOMER WHERE AGE = 3; it picks the right index. But my requirement is i need almost all the columns in such queries. How should i...

If you...

How large is the index in question? How many pages?

spatnaik77 (10/2/2009)

---

---------Now execute the following query and see the plan. You will see that it is a index scan-----

--Following query should pick the index IX_AGE but is not picking this...

Foreign key constraints, no. Unique and primary key...

xyzt (10/1/2009)

---

One user performs certain queries (from within the application) that no one else does and when he runs it, it takes much much longer than any other query in...

Mark Marinovic (10/1/2009)

---

Make sure you apply all diffs/transaction logs, etc (each with the NORECOVERY keyword at the end) and then when all of those have been applied successfully, use the...

Depends.

SQL 2005 and above actually measure duration in microseconds, not milliseconds. There's an option in the profiler GUI...

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Sounds like you're either...

Only if you want to slow the DB down as it...