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...

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!...

• This reply was modified 4 years, 5 months ago by  Jared.

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...

I did a post on this a couple of years ago here. It really is a good guideline, I have found.

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...

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...

Perry Whittle (10/21/2016)

---

SQLKnowItAll (10/20/2016)

---

I have designed hosts specifically for only 1vm. If you believe you can't get the same or better performance after virtualization, I'm sorry for you. There's not...

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...

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...

Perry Whittle (10/20/2016)

---

:w00t: wow...

Perry Whittle (10/20/2016)

---

Virtualisation carries an overhead,...

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...

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?