I just want them to fix the serious performance problems that started in 2019 and they've done (apparently) nothing to fix even up 'til today for SQL Server 2022....

You are going to have to provide a lot more detail for anyone to give you a sensible answer but, from what you are saying, this sounds more like an...

Before you delete that data, as a minimum I would BCP it out and save it securely somewhere. Long term you might want to look at partitioning the table so...

Strong suggestion, don't store the images in the database. Can you? Yes. VARBINARY(MAX) would be the way to go. However, it really negatively impacts a whole slew of things...

Thing is it will be in file format. I mean converted table data in to file and then moved data...but i f there is need to see the data...

dbo.clan.spouses is a 3 part name where dbo is the database, clan is the schema and spouses is the table.

Looking at your screen shot you probably want dbo.[clan.spouses], where dbo...

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

The error message would help but I strongly suspect it is objecting to converting 'this is a string' to numeric. Search for TRY_CONVERT().

• This reply was modified 10 months ago by Ken McKelvey.

I cannot help you with this as I do not use...

You need to put SQL in a Query Window. This can be opened on the top left of SSMS.

dbo is the default schema. You can create your own schemas to...

This is a MS SQL Server site so will not normally deal much with web developemnt. It may be best to look at https://stackoverflow.com although you had better check...

While better than nothing, I doubt many people use maintenance plans. I use the following:

https://ola.hallengren.com/

and

https://www.brentozar.com/archive/2017/03/databaserestore-open-source-database-restore-stored-procedure/

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

One solution would be to copy the data to a centralized database/warehouse and report from that.

https://learn.microsoft.com/en-us/answers/questions/1186978/is-it-possible-to-create-a-linked-server-from-azur

I have never come across this either.

The first thing I would do is run Brent Ozar's sp_blitz. As well as the health check, there are parameters which allow you...

The simple approach would be to put your query in a CTE with

,ROW_NUMBER() OVER (PARTITION BY Model ORDER BY Cal DESC) AS rn

and then SELECT FROM the CTE WHERE rn...