Viewing 15 posts - 1 through 15 (of 2,646 total)
Thanks for the interesting post. I believe it is cool from a "can I do this?" perspective, but what would be the practical use case of such a transpiler? If...
November 2, 2020 at 12:51 pm
The reason for the "strange" syntax is ANSI: PostgreSQL and Oracle already have this function and it is the same way. Great article to expose more people to this function!...
October 2, 2020 at 12:42 pm
Couple of things here:1. I would not blanketly disable auto update stats. In fact, I would "almost never" disable auto update stats. Its a good idea to update stats...
October 30, 2018 at 7:34 am
I did a post on this a couple of years ago here. It really is a good guideline, I have found.
October 9, 2017 at 4:53 pm
March 31, 2017 at 9:29 am
March 29, 2017 at 3:19 pm
I don't think it's fair to say that extra CPU makes up for lacking disk performance. Your test operations are almost purely io, so CPU is almost irrelevant. Also, what...
February 15, 2017 at 6:30 am
I think this is all an "It depends" thing. In today's world, many of us are on on all flash arrays. I have tested autogrowth of 8GB on the log...
December 17, 2016 at 10:43 am
Perry Whittle (10/21/2016)
October 21, 2016 at 2:57 am
To the op. My first response here said that you shouldn't assume a negative impact of virtualization.
1. Your are probably moving to new hardware
2. If done right, your are...
October 20, 2016 at 8:17 pm
Again, I agree to disagree. And again, I'm not saying that virtualization is done for performance. However, it is absolutely possible to get better performance with virtualization. Also, it's not...
October 20, 2016 at 7:19 pm
Perry Whittle (10/20/2016)
SQLKnowItAll (10/20/2016)I suppose that depends on how you measure "overhead." I still stand by my statement that "in general" a properly configured VM can boost your performance.
October 20, 2016 at 8:05 am
SQLKnowItAll (10/19/2016)What makes you say there will be negative performance impact of virtualization? I would say "generally" you can get a bump in performance.
Virtualisation carries an overhead,...
October 20, 2016 at 6:00 am
Example: The users who are viewing the data do not need to know that the data they are looking at might be changing or where small changes in data do...
October 19, 2016 at 7:25 am
Is all of the hardware and configurations between the nodes exactly the same? Down to disk level? Drive letters? Sector size, offset, allocation unit on each disk?
October 19, 2016 at 7:10 am