I have had to do similar things, such as changing the clustered index column or 'correcting' varchar(max) to varchar(pick-a-number). Sad to say my bedroom wall is covered in scribblings, I...

I do not understand why you are keen on separating natural and surrogate keys.

In my experience any rules that require thought and skills to implement very rarely survive the tenure...

Grant is totally right.

I will add my voice to using snapshot isolation level, it fixed a shed load of blocking problems in my old place, particularly those from third-party applications....

A man named Paul once wrote "All things are possible but not all things are desirable".

An upgrade in place should work, but scores about 9.9 out of 10 on a...

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 3 years, 4 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,...