Add a group by

GROUP BY saleddate, sales_count

One million points?  I have 26,435.  I should hit a million by the time I'm as old as Jeff.

Correct.  But depending upon the sizes of your databases, this can save an enormous amount of time.

xp_fixeddrives  will get you free space.

Actually, this can be done.

https://www.sqlskills.com/blogs/jonathan/downgrading-sql-server-editions/

I've used this method in the past successfully

If I knew how to do it I wouldn't be asking or maybe I'm just posting for the fun of it?

The image is only an example.

Or maybe you could...

What account is the snapshot SQL Agent job running as?  It needs to be sa.

Ok, so you totally understand all aspects of an execution plan, and understand how...

Why do I feel like the thread below is a bunch of people in an autopsy room, with a dead body that was killed by a shotgun blast, and all...

get only columns data1,data2 from first index with 'a', 'b' and for each one only the 2nd index val=1 filter_1 = multi_indexed_DF.loc[(['a','b'], 1), ['data1','data2']]

# get only those entries where...

Thank you very much for the reply on this.  I am still working on this project.

I have build a new server and added it to the cluster in the...

I removed the Distinct and tried to cast on attvalue but I'm still getting this error in query plan.

Type conversion in expression (CONVERT(int,[d2].[attValue],0)) may affect "CardinalityEstimate" in query plan...

Try this link:

What is SQL and how it work

Maybe this?

WITH OrderGroupOnly AS (
SELECT OrderID
FROM OrderProducts
WHERE ProductID IN (1,2,3)
EXCEPT 
SELECT OrderID
FROM OrderProducts
WHERE ProductID NOT IN (1,2,3)
)
SELECT C.CustName, O.ID OrderID, O.OrderDate, P.ProductDesc
FROM dbo.Orders O 
INNER JOIN dbo.OrderProducts...

I ran this query to show me the execution count of the nightly process. The query that was number 1 of the list was a

(@1 nvarchar(4000),@2 nvarchar(4000)) DELETE [bom]...