I think I have come up an explanation. Part of it comes down to parallelism. The straight select has a parallelism of 1, the select distinct has a...

For a better response, please read the following article. It provides excellent guidance on asking for help.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

There are plenty of people out here who would like to help, but...

And I will second Jeff's assertion.

😎

For the DR site, I'd go with log shipping. If you use HA mirriorring (automatic fail over), and you have a node failure in your cluster, the mirrior will...

The problem here is that we haven't seen the entire execution plan, only what we have been told. Again, the cost is relative to the batch its self, and...

Read BOL (Books Online), it will provide you all the info you are asking.

😎

Just throw them some prok chops!

:w00t:

But this has been a fun and entertaining thread where people have been open, honest, and shown a great deal of humor.

A great distraction from the mundane aspects of work.

😎

Sarvesh Kumar Gupta (3/13/2008)

I have a table there are three columns:

1. Id_Pk

2. Emp_Name

3. Salary

Some Salary fields have Null, Now i want to select table data in such a way that...

I think the threads about Bankers Rounding (I know of two threads on this topic) may be longer.

😎

Here is the output from having STATITISTIC IO ON:

SELECT -

Table 'studemo'. Scan count 1, logical reads 5674, physical reads 2, read-ahead reads 5717, lob logical reads 0, lob physical reads...

Also, remember that the query cost is relative to the batch. The in the faster query, the relative cost is 73%. In the slower batch, the cost you...

Don't think so. If that were the case, the first query when run again should have been quicker. It was consistantly 27 seconds.

Honest, all you wizards out there...

But that doesn't change the PK/FK relationship.

I know, I told the person who told me what our former employer paid, and he was SURPRISED!