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.

Usually, I'll start with the lecture and then provide an alternative. Today, let's mix things up and start with the alternative. Check out Gail's blog post on catch-all queries....

• This reply was modified 6 years, 4 months ago by Grant Fritchey.

Oops. Wrong window.

• This reply was modified 6 years, 4 months ago by Grant Fritchey.
• This reply was modified 6 years, 4 months ago by Grant Fritchey.

Personally, I'd lean towards using a unicode column and store the data as needed. I mean, what happens when you add German, Swahili and Sanskrit? Translate or format on the...