https://stackoverflow.com/questions/7086393/create-html-table-with-sql-for-xml/39487565#39487565

https://learn.microsoft.com/en-us/sql/xquery/flwor-statement-and-iteration-xquery?view=sql-server-ver15&redirectedfrom=MSDN

Why are you trying to install SQL Server 2005 when the lowest supported version is SQL Server 2016?

What version of Windows are you trying to install SQL 2005 on? I...

It is the SQL Server VSS Writer service which writes details of VSS backups to MSDB so that is where to start trouble shooting. Check the service account, check the...

• This reply was modified 9 months, 1 week ago by Ken McKelvey.

The SQL Server VSS Writer service is probably disabled. It might have been disabled if it was interfering with SQL Server backups.

Before relying on someting like Veem, make sure you...

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 9 months, 2 weeks 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 9 months, 3 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...