We have a database that has been in operation for several years now.
Periodically, as the data has grown, we've performed index analyses and
added new indexes to help boost performance.
Is there a way of running some sort of trace on SQL Server to show which

Hi all. I got the next very simple and strange problem. When running the
following 2 slqs, one runs very fast, and one very slow. I looked at my
indexes time and time again, and cannot figure out why. The table has about
8 million rows.

I read some articles which says that the alignment (offset) of the partition
is important.
but does anyone has some numbers?
does anyone has perform some benchmark after/before setting up the alignment

I want to know where is the list of trace flags available in SQL 2005.
Specially those used in the TPC-H benchmarks: (so data warehouse usage)
-E : ok
but sometimes I see over flags: