Thank you Guys, and I do apologise, I should have clicked on the link in the blog for the scripts.

Sorry for making this to drag on like this.

Attached is a real example from one of my databases (not my design BTW). It shows a table with 2 first columns....

Hello,

I've studied some of the MS documentation and I may have some additional questions. My main aim is to understand how to reorganize one of my databases. In order...

Lynn Pettis (5/24/2016)

---

paul.bowman (5/24/2016)

---

Steve Jones - SSC Editor (5/24/2016)

---

paul.bowman (5/24/2016)

---

Also sometimes what appears to be the natural primary key, from the point of view of the data model and retrieval...

Steve Jones - SSC Editor (5/24/2016)

---

I really dislike opening statements like this. You are almost implying...

Hi,

there is one phrase I don't understand in this article:

http://www.sqlskills.com/blogs/kimberly/ever-increasing-clustering-key-the-clustered-index-debate-again/

What does this mean?

Lookup key...

Hello,

I am normally an Oracle guy, but even from that perspective I would have the same approach with SQL-Server. Yes, document everything you do when doing an upgrade. The...

Yet another blog type article, why do people feel compelled to tell every possible story they have to tell? No toy women soldiers? So what? It's one of those linkedin...

Many applications are now written to be executed in a web browser which in itself poses a threat, because users may use multiple tabs and have sites opened that run...

When I first started working as a DBA in 1996 I went to practically all Oracle database admin courses, SQL, Pro*C, Forms, etc. The company valued knowledge at that time...

P Jones (7/9/2012)

---

The only ones who see us as a "tax" on company computer systems are the technical/network managers who can't understand why we do so many backups and need...

Hello,

I can see people are still praising the article and yes, it's an excellent piece. I have actually wrote the hints into a health-check script, it's in one piece...