You could also look at asking your network team to create a load balancer and then use the load balancer in the connection strings.

Once all the connection strings are pointing...

"this is not enough of an annoyance for most people to seriously start looking at something like PostgreSQL"

Most? Probably still true. But they might want to re-evaluate their over-confidence...

Would upper management actually realize if you used .Net 8 instead of .Net 2? Would they realize...

An interesting article:

What the Decline of Sql Server Quality means for Developers and DBAs

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 1 years 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 1 years 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 1 years ago by Ken McKelvey.