Although there is a solution provided to the OP that works, I have to ask what the original reason is for trying to build a string based GUID...

The worst schema I had to implement: A customer wanted us to reboot the server for patches on the first friday of the month around 1am.

How do you schedule...

Mostly but, personally, I wouldn't...

Thank you Jeff,

I have been emailing them everyday since last week. Did not get any response, therefore started a thread here.

Any other email or person I can reach out...

Although there is a solution provided to the OP that works, I have to ask what the original reason is for trying to build a string based GUID base on...

If the clustered index has an ever increasing key and the inserts are following that key, you won't get page splits.  If, however, the inserts are followed by "ExpAnsive" Updates,...

To be honest, you need to challenge their design... this table is a HISTORY table!  Why are they updating a HISTORY table?  It should be an INSERT ONLY table that...

You need to send an email to webmaster@sqlservercentral.com to get this fixed.

You need to send an email to webmaster@sqlservercentral.com to get this fixed more expeditiously because they don't typically monitor this particular forum and I'm pretty sure they don't have actual...

Thank you Jeff.  44.9% or 31%?  Either way there's no implicit type conversion 🙂

Ken McKelvey's solution in the "Pivot with grouping intervals" topic is interesting.  It cross join's a...

You could test if the modulo .1 of HRS equals zero

;WITH cte_data AS (
    SELECT CAST(50.10 AS numeric(5, 2)) AS HRS
  ...

Nearly duplicate post with an incorrect improvement calculation removed.

Very interesting to think of how differently this concept can be thought about 6 years later than it was originally published.  Since then the fact that people use data...

Try installing the table valued function here: https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function

Then to select 15 minute intervals as in your example:

SELECT Value
  FROM dbo.DateRange('1900-01-01 00:00', '1900-01-01...

With all the automatic query tuning stuff they did in 2022, who knows how the optimizer estimates things now?

It'll be interesting if anyone shows up that actually knows.