Hard to believe that such a functionality exists.

Your way is just fine, you're keeping the aliases for the columns set up from all users and then use them. Very user-customized....

Why do you choose the harder way? You have that in SSMS: right click on a database - > tasks -> generate scripts and then you have the many options...

Alan.B (5/31/2016)

---

I don't know why you get an error. This code

CREATE TABLE Mytest (id INT, x XML)

INSERT mytest

VALUES

(1, CAST('1200' AS XML))

...

Agree with this.

I think I had that problem with SSMS 2008R2 and had to upgrade with the next CU in order to overpass...

Isn't the number of rows restricted in query designers?

You can just download the latest CU and upgrade with it.

https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-updates-to-the-sql-server-incremental-servicing-model-ism/

I run your script on sql server 2014 and 2016 instances and it doesn't return any results.

Perry Whittle (5/31/2016)

---

Igor Micev (5/31/2016)

---

Grant Fritchey (5/31/2016)

---

TheSQLGuru (5/31/2016)

---

What SSDs did you...

I was...

TheSQLGuru (5/31/2016)

---

Igor Micev (5/31/2016)

---

Grant Fritchey (5/31/2016)

---

TheSQLGuru (5/31/2016)

---

What SSDs did you have?...

Grant Fritchey (5/31/2016)

---

TheSQLGuru (5/31/2016)

---

What SSDs did you have? What was very...

My experience with SSDs on a write-intensive instance was very bad. The SSDs went out for 2 months.

frederico_fonseca (4/27/2016)

---

I see to main issues here

1 - VM setup seems to indicate an issue if performance of HD's is that bad compared to the physical.

What is the...

Hi friends,

I'm coming back to this thread after investigating the issue with sys admin guys. I checked the settings Grant asked, and they are all identical.

Thanks for the initial replies.

The...

Grant Fritchey (4/6/2016)

---

It is VM vs. Hardware, which can't be discounted. Just because the resource settings in the VM are the same as the hardware doesn't mean they're actually the...