Thanks for your reply Perry

I have already read all of your excellent Stairway to AlwaysOn series.

Just to be absolutely clear then. If we want to use...

Hi

Thanks for the answers I used Eirikur Eiriksson answer in the end because I found the code easier.

Looks...

I completely agree but I'm not in control of the purse strings! If the price comes in too high there will be no upgrade, so I have to tread carefully.

Hi Guys

Thanks for all the answers, especially interested in the possibility of the optimiser not being able to use stats.

The Tsql I posted is actually a...

Yeh thanks for the replies.  I hadn't refreshed my browser so I didn't see Gail's first reply.

Excellent as ever 🙂

I can't take a backup immediately afterwards. I just wanted to know if there was a downside to setting everything up and letting it start once the scheduled backup kicks...

I read that.  Does that mean it behaves as Simple recovery mode and overwrites transaction logs at checkpoints until a full backup is taken? do you know what would happen...

Optimise for unknown query hint means when the SQL engine compiles an execution plan it ignores the parameters in the code and creates a plan from average value. This creates...

Hi Nader

It's always worth remembering that it's execution plans that do the work on SQL not SQL code. The same code can run in completely different ways depending...

Hi Sue

I've not seen that DMV before and it's solved (or at least I know the cause now) my problem

Although the set_options were 251 for the...

Hi

Looking at the plans the slow plan is mainly using Nested Loops and the Fast plan uses more Hash Matches.

In the slow plan there's a massive...

That makes sense.

Thanks Gail

Hi

Thanks for the replies.

I looked in the SQL log and it looks like there was a memory issue at the time. This "LazyWriter: warning, no free...

I tried that before I posted. It's a sea of red and returns Incorrect syntax near 'NOT'.

Thanks for the reply Grant.....

I'm not really looking for a specific answer for this issue, more for suggestions of things I can tweak.

Aside from adding predicates...