If you have tables with fewer than 200 rows, the statistics won't be changing very often unless you're doing lots of replacements of that data, so I don't see how...

Development is where development and testing occurs. No production information should be stored there. You certainly shouldn't have weird cross server queries from production to development. This is a fundamentally...

I don't see anything in what you posted to suggest that it's a cache problem. If you have two instances on the server, make sure each one has a max...

Never a doubt in mind!

Ha!

WHOOP!

All those classes on how to use Extended Events haven't been wasted.

And before there's more whinging about XML in Extended Events, let me point out two things. Using the Live...

Not a problem. This is the kind of stuff people really need right now. I hope it helps.

I'd be buying radio gear, but Mrs. Scary has me cut off.

I'm not sure what you mean, DLL references. You'll have to clarify.

Can you query an Azure SQL Database and output the results to a local file like Excel? Yes. Pretty...

Yeah, you have to save them as XML and then they can upload.

Index hints are EXTREMELY hit or miss and mostly miss. The plan will show the index being used,...

Just getting the Execution Plan should be enough. Getting the Plan Plus Runtime Metrics won't add much to your information. Use the "Estimated Plan" button and that will give you...

Have you looked at the plans yet to see what the differences in row estimates and behavior are?

I read through the update notes. I didn't spot anything that looks...

So it is a parameter & not a local variable?

Hmmm.... What about making it a local variable. Instead of doing the calculation on the date value there, do it on...

YAAAAAAYYYYYYYY!

#TeamXE

Is @EndDate a parameter or a local variable? If it's a parameter, I would assume that parameter sniffing should, in general, give you similar performance to having a hard-coded value.

However,...

Incorrect connection string. No open port. No open IP address. Something network related for sure. Check that the listener service is running. Gotta be something along these lines because if...