@Wecks ...

Since these are CDRs, do you need to obey such rules as the classic "Whole minute rounding (up) per call" rule or any other some-such rules?  Either way, which...

Create some test data:

DROP TABLE IF EXISTS #temp
GO
SELECT *
INTO #temp
FROM (VALUES 
(001, CONVERT(DATE,'2023-02-23'), '123', 'a@a.com', '10:23:00.000', 500, 'W'),
(002, '2023-02-23', '246', 'b@b.com', '09:36:00.000', 456, 'W'),
(003, '2023-02-22', '123',...

Unless I'm missing something in the requirements, "awesome SQL" isn't required here... just a GROUP by on the columns you mention, a COUNT(), and a SUM() of the CallDuration column. ...

No.  I don't avoid it.  I never write things that way but I don't change them if I come across them.  As you say, it doesn't cause any issues except...

The only time I've seen one like that is when someone use the "Query Builder" functionality and only in what I refer to as a "Skip Join" where Table A...

ARPRINCE,

Have you looked at the query plans for the two queries?  The LEFT JOIN method is doing a full table scan per join.  That could be a (big)...

Be careful of "old" tutorials on this one.  They HAVE changed it, especially starting in 2019 (according to the MS documentation) and some of the "old" methods may no longer...

Interesting... the first time I clicked on it, it took me to a page selling hair-care products with that picture on it.  I just clicked on it again and, you're...

I'm thinking that may have been their goal...

If you've been running without partitions for 12 years or so, why add them back? Partitions are all about data management, not performance. If you're not dealing with all...

@krypto69 ,

Thank you for the DDL.  I'll take a look at that and your code tonight after work tonight.

Just to double check after a quick scan... I see no Clustered...

Dealing with a super huge table that is partially partitioned can be a challenging task for many database administrators and developers. However, with the right approach and tools,...

If it is and you're concerned about the page splits (I usually am because they can cause...

Heh... not exactly SkyNet yet but, first drones and now this...  and, guess what?  It doesn't have to eat or pee. 😀

https://finance.yahoo.com/news/an-ai-agent-flew-a-usaf-training-aircraft-for-over-17-hours-185930689.html

One of my other issues with these 'bots is that they don't provide many choices.  When I ask a question in...