Jeff, beauty thanks! This is excellent.

I am looking forward to tomorrow to trying this out. That traceflag  looks super not just for this hurdle but for some future...

I like this method a lot. I shall give it ago on test soon.

Iincidentally, the script eventually failed with an out of log space message. Indicating that the...

This is a 4.5 TB database.
There are 9 file groups and two logs.

This table resides on a single filegroup.

All the indicies and keys have been...

Aye, I supose it is quite large amount of data. Just in my mind it only takes 12 hours to restore the entire DB which is also IO bound. And...

Morning 🙂

Sp_spaceused returns the following:

name;rows;reserved;data;index_size;unused
my_table;197836642;198715216 KB;132216576 KB;66036736 KB;461904 KB

It actually contains closer to 200m records not 100 like in my first post.

I should add that I can isolate Post Code separately with some string manipulation.

It's just the remaining number of field that are unknown. Could be 3 fields,...

[This site does not play well with Edge!]

create table SourceAddress
(
    [AddressData] varchar(max) not null
)

insert SourceAddress(AddressData)
values('51 Anonymous Street//London//NA1 4PQ'),
('The Ugly...

The configuration for the instance is correct in as much as out of 600 or so different queries, only a handful are helped by lowering the maxdop value.

Which...

Hi Luis,

I was asking if there is a way to determine from looking at a query or its execution plan if one can tell if any improvement would...

Brilliant John, cheers!

Guys that's brilliant, thanks a lot.

Both really great links!

Thanks Gail. Worked perfectly after doing that.
Owe you beer as that was really annoying me. I even tried pressing F5 harder in case that helped.

Here's the screen from my AG and the source of my confusion on failover order:

Okay.

How does one change the order in which fail over occurs.

If I have 4 SQL Server 2016 instances: A, B, C and D

And...