There is more than one way to switch a roo.

Renaming servers the way to go but the roo you switch first should be your existing server name. When you change...

• This reply was modified 2 years, 9 months ago by EdVassie.

I totally agree with the previous two posts suggesting you reconfigure the workstations to use a DNS alias. It will be painful but it will make future migrations much easier.

As...

I forgot to say in my previous post, please do not use locking hints. These very seldom give any benefits but very often harm performance. Always write code that assumes...

You will need to write code that can trap the duplicate insert condition and take the action you desire in this situation. Typically the code you need will be packaged...

People coming to SQL Server from a DB2 background may consider PLE to be a significant metric. But on DB2 the DBA can create multiple buffer pools and assign objects...

First of all, do all of this on a non-production system so you find out what to expect when you do it on Production. If you do not have a...

You have already done some basic troubleshooting, so tracking down the problem may not be easy.

The code producing the message is core functionality so the message has to be taken as...

BTW it is so long since I ran SQL Server on anything other than a guest machine I have forgotten what it looks like. Running under Hyper-v is fine.

Can I add a big thumbs up to this.

You obviously need to check your environment to eliminate obvious performance bottlenecks, but after that try to get the software vendor involved....

I think you should choose ehatever you feel most comfortable with. There will be new things you have to learn to get this working OK. Set up a test environment...

Yes you can use a normal AG across the two sites. If you use SQL2023 you can additionally use a contained AG which has the advantage of replicating all jobs,...

The short answer is Yes, you can do this.

At my old place we had two sites, each with a Windows cluster. Each Windows cluster had a SQL cluster installed with...

The size of a Windows event log is configurable. If the log is cycling too quickly, then one solution is to make it larger.

All queries (should) only exist to solve a business problem. If the only way to answer this business problem is to sort on column-encrypted data then maybe the business problem...

• This reply was modified 2 years, 10 months ago by EdVassie.

You started by saying you were experimenting with full text search and some alternatives. You seem to have ended in a rabbit hole wondering why some queries run in parallel.

Jeff...