I agree. These would...

For more info on the duplication from the dmf, this article outlines what is happening:

http://bit.ly/1lzDKLO

[/b]

Even on SSD the fragmentation will be an issue. The linking of the file segments is managed outside of sql server, so no map within SQL Server.

While specifically about index...

mhickin 11975 (1/21/2016)

---

If you use mount points, then the approach outlined here isn't going to do do much for you.

Also, if you are using clusters, then it's often useful...

Well, if Hugo did his best, I won't even look. 😉

Ed Wagner (1/20/2016)

---

SQLRNNR (1/20/2016)

---

Alan.B (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything...

Alan.B (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long,...

Ed Wagner (1/20/2016)

---

Tell me The Thread's award is not that it's going to be killed off. I've come to enjoy it. It's a lot like a pressure release...

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It...

Where are my manners?

Well done on the article, Ed!

HAHAHAHAHAHAHA

Arjan Fraaij (1/19/2016)

---

Hi very nice article.

Only xp_cmdshell is not always enabled, because of possible security reasons. From SQL Server 2008R2 the Dynamic Management view sys.dm_os_volume_stats can be used. So I...

Anybody notice the new hair style?

Brandie Tarvin (1/19/2016)

---

SQLRNNR (1/19/2016)

---

BL0B_EATER (1/19/2016)

---

SQLRNNR (1/19/2016)

---

GilaMonster (1/19/2016)

---

Talking about dressing up a CV, the last time I used an agency (well over 10 years ago), they sent me to an interview....

BL0B_EATER (1/19/2016)

---

SQLRNNR (1/19/2016)

---

GilaMonster (1/19/2016)

---

Talking about dressing up a CV, the last time I used an agency (well over 10 years ago), they sent me to an interview. At the time...