Unless the "with the matching dates" is to be interpreted as a date range selection, in which case Jeff Moden's integer math would be needed to ensure that the...

@Wecks ,

We still need an answer to my questions about the required rounding. Thanks.

EDIT:  Never mind... forgot to refresh before posting this.

@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...