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

This minor change (IIRC)...

BULK INSERT OSPRetail.dbo.DimProduct5
FROM 'C:\Users\User\Downloads\data feed.csv'
WITH ( FORMAT = 'CSV',
FIELDTERMINATOR = ',',
ROWTERMINATOR = 0X0A);

Also, read up a bit on the BULK INSERT and learn the...

Its managed SQL Server Business critical, with the latest version, and MS automated management of Log file.

The issue here is there is purge and archival of data creating lots...

Please...