You could try one of the following hints at the end of the SQL:

OPTION (OPTIMIZE FOR UNKNOWN)
OPTION (RECOMPILE)

Given that the table had no index at all, I didn't think in this case that making the clus index unique was necessary, particularly to the extent...

I don't know,...

Well, the issue with MONEY is that who's to say monetary amounts should always have 4 decimals? Often it's too much, and sometimes it's not enough. And if you...

To some extent, it gets worse with larger numbers. Try this:

DECLARE @tmp1 FLOAT = 10e27;
SELECT CONVERT(decimal(38,2),ROUND(@tmp1, 2)*100),
       CONVERT(decimal(38,2),ROUND(@tmp1, 2))*100,
 ...

Yes, a strange result. Try this:

DECLARE @tmp1 FLOAT = 0.289;
SELECT CONVERT(decimal(38,36),ROUND(@tmp1, 2)*100),
       CONVERT(decimal(38,36),ROUND(@tmp1, 2))*100

-- drop all user defined stored procedures 
Declare @procName varchar(500) 
Declare cur Cursor 
For Select [name] From sys.objects where type = 'p' 

Open cur 

Fetch Next...

Select PP_SUPP.PP_SUP_NO SupplierCode,
       PP_SAD.PP_SAD_REF SupplierAddressCode,
       GD_CST.GD_CST_FNAME SupplierFullName,
       GD_CST.GD_CST_ADD1 SupplierAddressLine1,
...

Looks ok to me.

If you want non-integer averages you can do this by adding 0.0 to the count:

with postcount (postid,postcount) as 
(
select postid,count(relatedpostid)+0.0 as postcount 
 ...

<li style="list-style-type: none;">

• yesterday about 13-17hours was possible run this query only with MAXDOP 1,2,3,4

<li style="list-style-type: none;">

• yesterday after 18 and more was possible run only with...

The plan looks the same, the estimates are the same, and it even continues to suggest that I create that same index that I just created. (Yes, it's really...

What happens if you create the suggested index? Do both queries use it?

There is no difference in the execution plan. Just the number of rows estimated.

There is quite a lot wrong with your SQL, I've just pasted in something that will work.

drop table [dbo].[Table_1]
GO
drop table [dbo].[Table_2]
GO
CREATE TABLE [dbo].[Table_1](
[KEYU] [int] IDENTITY(1,1) NOT NULL,
[DATA1]...

There is no difference in the number of reads, so maybe (as the optimiser is a bit of a black box), in that case, the optimiser doesn't change the order...