Viewing 15 posts - 1,906 through 1,920 (of 22,202 total)
Hi Grant,
I am little bit stuck by the word "I/O throughput". Is it something related to data transfer or MB/sec?
Basically, how fast can you read from your disk into...
February 24, 2020 at 12:05 pm
No, forcing the index just means the optimizer will try to use that index. It doesn't mean it will perform a seek operation. You could use the FORCESEEK hint to...
February 24, 2020 at 11:58 am
Not a problem. That's what we're here for. Share the knowledge.
February 21, 2020 at 7:45 pm
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...
February 21, 2020 at 4:04 pm
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...
February 21, 2020 at 3:34 pm
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...
February 21, 2020 at 2:56 pm
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.
February 21, 2020 at 2:53 pm
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...
February 21, 2020 at 2:03 pm
Have you looked at Pure Storage? They do stuff that seems like magic honestly.
February 21, 2020 at 12:28 pm
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...
February 21, 2020 at 12:27 pm
Although, purely technically, just for Steve, aren't they called Friday Shirts? That would invalidate the answers to this question would it not?
February 21, 2020 at 11:59 am
Here, rather than try to really help, I just googled "open source in memory database". Here you go.
February 21, 2020 at 10:49 am
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...
February 21, 2020 at 10:48 am
What he said.
February 20, 2020 at 6:38 pm
Viewing 15 posts - 1,906 through 1,920 (of 22,202 total)