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.

So...

We "talked" on LinkedIn.  I provided a link to "BULK INSERT" and introduced "BatchSize" and "Tablock" to you.  You also found "Example f.", which is about how to do things...

I have to admit, I'm totally amazed about the number of people that participate on the QoD and on Polls on linked in.

I'm also amazed at the number of wrong...