The thing is, with one exception, I don't see indexing as a way to fix bad parameter sniffing. Indexes cause bad parameter sniffing. The one index I treat as a...

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

Well, the CHAR(1) can have how many different values if we're not talking the entire ASCII set, 36, alphabet & numbers. The histogram is 200 steps... well, in this case...

are we allowed to post links to "let me google that for you" ? lmgtfy.com 🙂 🙂

I've posted a lot of questions in the last few days relating...

We frequently raffle off Steve's shirts at the Redgate Summit events. I'm sure that will continue. Although, for everyone's comfort, it's a shirt he is not wearing and hasn't worn.

we had to drag info out of the original poster and Grant just googled "in memory open source" - ... i think he might have given up on that...

Have you looked at Pure Storage? They do stuff that seems like magic honestly.

Let's start with the obligatory, it depends.

I wouldn't, myself, describe a covering index as a solution to parameter sniffing. Instead, what a covering index can give you, depending on the...

Although, purely technically, just for Steve, aren't they called Friday Shirts? That would invalidate the answers to this question would it not?

Beautiful Hawaiian shirts.

Here, rather than try to really help, I just googled "open source in memory database". Here you go.

For I/O, here are a couple of articles on how to track it and understand it. I'd still recommend getting a copy of the execution plan plus runtime...

What he said.

Thanks for all the feedback on this one everyone. Good to hear.

Much less enjoyable are the people who have decided that because I’m an expert, whatever that means, that I have to have all the answers, all the...

And, of course, you're 100% correct on what you showed with the compatibility levels.