What do you mean per slot? Per port yes, but you can get dual ported HBAs which will double that, so 2 dual ported cards give you 2GB/s. And that...

We use fusionIO for tempdb too, beautiful! But why all the messing around with PCI expansion etc, if you need more space than you can squeeze into a box why...

Yeah, thats what I figured, I guess I was just hoping there some quick we function I could pop in somehwere that would make the optimiser know it was invalid...

We have an application where all SQL access is via a standard data access layer. I'm trying to get them to build in a usage of the context_info to set...

Yeah I did think of that but presumably if I'm happy with the parameters I optimize for will give me a good(ish) plan every time then it is better to...

This is what I ran to get the plan of the statement as it was running, is this right?

select r.plan_handle,p.query_plan

from sys.dm_exec_requests r

cross apply sys.dm_exec_query_plan(r.plan_handle) p

where session_id = 143

That's where I got the bad plan in the first place I'm afraid. I was a little surprised to see it was an estimated plan though.

Ah no chance there. When you profile to get plans I can never get any filter to work that doesn't cripple the system. It only ever happens in prod and...

Unfortunately I can never actually get the actual execution plan, when I run the query manually it always gives me the good plan. The bad plan was extracted out of...

Yup can do, I've put the good and the bad plan in there for comparison.

OK here you go all the gory details, it all looks OK to me. This is view...

ALTER VIEW [dbo].[vwConsolidatedCLT]

AS

SELECT CLT.TransID, CLT.LedgerDate, CON.ClAccountID, CLT.ClAccountID AS subclaccountid,

CLT.LineNumber, CLT.MovementType, CLT.MovementSource, CLT.CCYCode, CLT.Amount,...

Actually no, but now that I've been forced to think about it in a logical way to explain it here, I might have been making too many assumption about what...

OK thanks, that surely can't be right though! We have a bit of bad design here and there too but this particular section looks OK and it isn't an unreasonable...

Sorry should have mentioned , been there done that. It does kind of make a difference but only for a day at most and there isn't enough activity on the...

Yup I'm with Marius, the results would not be what is intended and therefore the query is just plain wrong, which is different to a syntax error as offered in...