You could generate the code as dynamic SQL to cope with different numbers but you would need to check carefully how efficient a value of 100 was.

Whatever you are trying...

• This reply was modified 5 days, 19 hours ago by  Ken McKelvey.

1. I hope you are not using floats for prices!

2. Do you really use reserved names for columns?

3. Are you really writing new code with the depreciated order by column...

This smells like a permissions issue for the SP. I am not anywhere I can test this but I suspect you will need to sign the SP and then have...

Or combine with the unique ordering column:

SELECT UNIT, PURCHASE_DATE, METRIC1
,CAST( SUBSTRING( MAX (
CONVERT(char(8),  PURCHASE_DATE, 112) + CAST(Metric1 AS varchar(20))
)
OVER (
PARTITION BY Unit
ORDER BY PURCHASE_DATE
ROWS BETWEEN UNBOUNDED...

My limited experience with AI at the moment, with regards to code, is that it is not very good. It can, however, provide a good starting point if you have...

For large volumes of data, I find BCP to binary files works well enough for me

You could try:

1. BCP out to binary files using the partition conditions.

2. BCP in again...

What makes you think this?

Nothing to do with locking.

Will not affect UPDATE locks...

• This reply was modified 2 weeks ago by  Ken McKelvey.

You should know how to use date functions by now!

1. DATEADD(minute, -15, CURRENT_TIMESTAMP)

2. ROW_NUMBER() OVER (PARTITION BY DATEDIFF(minute, '2000', datevalue), floatvalue ORDER BY datevalue) AS rn

Server memory configuration options - SQL Server | Microsoft Learn

I do not expect much of it to reach on-premises SQL Server anytime soon as it would not surprise me if Microsoft announced it was moving to five year...

I suspect a lot of AI for analytics especially for security and BI on Azure.

I do not expect much of it to reach on-premises SQL Server anytime soon as it...

  Why?

What reseach have you done?

What methodology did you use?

https://www.apesoftware.com/calibration-control/help/sql-remote-connections

All this should...

Are you using Windows authentication to connect to the database?

If so you might have a Kerberos double hop problem.

If you do, try checking the SPNs with the Kerberos Configuration...

• This reply was modified 2 months, 2 weeks ago by  Ken McKelvey.
• This reply was modified 2 months, 2 weeks ago by  Ken McKelvey.