I know how to obtain the query stats, the problem is that when you're in query analyser you can't copy the query stats results. How do I get teh results...

How would I go about posting the query plan?

The old hardware was a 4 dual xeon processor with 8gb RAM. The new hardware is a IBM 345 2 dual processors and 4gb...

How would I go about posting the query plan?

The old hardware was a 4 dual xeon processor with 8gb RAM. The new hardware is a IBM 345 2 dual processors and 4gb...

Hi there,

Below is the table structure and indexes used on table:

Columns

	Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
	unit_number		varchar	20

I have an index for the bloodgroup setup. As for the query execution plan I have run it but it does not make any sense to me. It gives a...