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...

I'm not aware of a change like you're describing. Microsoft always publishes a "what's new" article on each version. Look through there. Do you mean the new verbose...

Stats, no so much. Comments, tons.

The key to understand how Microsoft develops and releases SQL Server in this modern age is Azure SQL Database. With a few exceptions, all the...

Good news. You can get nonclustered index use as long as the INCLUDE list contains the columns you're using in the CHOOSE command in the SELECT clause. Blog post will...

Already part way into testing. With a clustered index, and CHOOSE in the SELECT, no affect on performance whatsoever. Working on the next bit now.