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...
Jared
CE - Microsoft
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!...
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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.
Jared
CE - Microsoft
October 9, 2017 at 4:53 pm
Jared
CE - Microsoft
March 31, 2017 at 9:29 am
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
December 17, 2016 at 10:43 am
Perry Whittle (10/21/2016)
SQLKnowItAll (10/20/2016)
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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.
:w00t: wow...
Jared
CE - Microsoft
October 20, 2016 at 8:05 am
Perry Whittle (10/20/2016)
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,...
Jared
CE - Microsoft
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...
Jared
CE - Microsoft
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?
Jared
CE - Microsoft
October 19, 2016 at 7:10 am
Viewing 15 posts - 1 through 15 (of 2,646 total)