Q: Sorry, but I'm not seeing it.  How would such a thing be used to improve the performance of the query the OP posted?

Valid point, chances are good it...

Ohhh... no extended comment from me... none of it would pass HR.   Let's just say that "I'm lovin' the lockdown" and seriously enjoy working remotely on all fronts.

Sounds like a prelude to spam...  why would anyone in their right mind try to take an average on such an identifier column?  Really bad question and, since you say...

One of the fastest methods ever created for doing this type of thing is documented in the following article.

https://blogs.solidq.com/en/sqlserver/packing-intervals/

It's an older article so solution #3 can be made work in...

This was an interesting subject that I'd not heard of before.  I checked and found the following article by Paul Randal.  What most interesting is his answer to one of...

Just out of curiosity sake, can you post the entire CREATE UNIQUE INDEX statement you were running to get this error?

Be advised that your post looks and smells like a precursor to spam, especially considering your other replies, which hadspam links...

Heh... yeah... but you'd first have to rebuild the index to partition it. 😀

Just exactly what does that "job" consist of?

And, yes... there's a way to do this (I do it all the time) but...

Hi Experts,

I ran the below query and for a table I am getting very high writes and its increasing every second. The table here is a master table which...

Heh.. I wouldn't use the "current logic"... it uses some pretty slow RBAR.  Use DelimitedSplitN4K, instead.

If I have a query with multiple UNION ALLs, will the optimizer try and grab enough memory to run all the individual queues in one, or will it make...

Since Tally Table of dates was mentioned, here is how to construct it:

1. create fnTally - table of numbers, by Jeff Moden, here  https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally
2. use the function to...

To compare data by using the New Data Comparison Wizard On the SQL menu, point to Data Compare, and then click New Data Comparison Identify the source and target...

Using joins to compare columns by priority among the table. For example, left join returns all values from the first table and null value for the not-matched records from...