🙂 Sorry, my fault. I need to clarify; the decision on fill factor is based on how often the index has to be rebuilt. GUID keys just cause a...

Well, one of the issues I ran into with OLA's script was related to how partitions are re-indexed. Keep in mind this is from memory, At least until now, online...

PHYData DBA (9/17/2015)

---

Keith Hays (9/17/2015)

---

PHYData DBA (9/16/2015)

---

I'm sorry but this looks like a (maybe not so current) re-write of something available at https://ola.hallengren.com/ for a very long time.

I...

PHYData DBA (9/17/2015)

---

Keith Hays (9/17/2015)

---

PHYData DBA (9/16/2015)

---

I'm sorry but this looks like a (maybe not so current) re-write of something available at https://ola.hallengren.com/ for a very long time.

I...

Replies seem to be working now. I started hold my head to the left and that seems to have fixed it. 😀

Your Name Here (9/15/2015)

---

I'd used a private "DBA" database for years until my latest position which involves a large farm of database servers dedicated to a prominent third party ERP...

I don't seem to be able to reply to more than one of you. The last reply shows up and the previous one goes away. I will wait a...

PHYData DBA (9/16/2015)

---

I'm sorry but this looks like a (maybe not so current) re-write of something available at https://ola.hallengren.com/ for a very long time.

I think the original article...

PHYData DBA (9/16/2015)

---

I'm sorry but this looks like a (maybe not so current) re-write of something available at https://ola.hallengren.com/ for a very long time.

I think the original article...

Good Info, its good to have specifics especially with licensing.

Some people may have skipped over the "covered by active SA" line. Software Assurance is not a cheap...

A couple things that I would add to what you might be pulling out of all of the rest of the comments I have read to far:

1. Clustering is...

Btw, I look like I have gone way off topic, but anyone looking to move to the cloud should look at some of the restrictions for full cloud based SQL...

I would note though, you do have to be careful of the calculators when translating from say 100,000 iops to their monthly "Storage Transactions" 100,000 iops is 260 Billion...

yeah, I am currently checking to see if azure has the equivalent of a P 50 (their nomenclature) P20 + P30 storage system per database system. If they do...

fregatepallada (12/18/2014)

---

bigint datatype occupies 8 bytes of storage

uniqueidentifier - twice more 16 bytes,

Therefore for each 1 million of records you got an overhead of extra 0.763 Mb for...