Mark Hickin (1/17/2006)

---

I think it's worth making the point that this approach does nothing to combat what is fundamentally bad about cursors. All we have done here is createda cursor,...

Eric M Russell (2/25/2015)

---

PHYData DBA (2/25/2015)

---

Eric M Russell (2/25/2015)

---

If I offended anyone here with my analogy, of a table having no primary key, to that of a feral child having...

Eric M Russell (2/25/2015)

---

If I offended anyone here with my analogy, of a table having no primary key, to that of a feral child having no name, then I'm sorry....

Phil Parkin (2/25/2015)

---

PHYData DBA (2/25/2015)

---

GilaMonster (2/25/2015)

---

PHYData DBA (2/25/2015)

---

Feral children don't read either. Please read the TechNet SQL BOL article called Heap Structures.

https://technet.microsoft.com/en-us/library/ms188270(v=sql.105).aspx

A heap is a table without...

GilaMonster (2/25/2015)

---

PHYData DBA (2/25/2015)

---

Feral children don't read either. Please read the TechNet SQL BOL article called Heap Structures.

https://technet.microsoft.com/en-us/library/ms188270(v=sql.105).aspx

A heap is a table without a clustered index.

I...

I have already provided this to butcherking13 but I am going to put it here since I am sort of amazed nobody has yet.

-- Query to show Missing Indexes...

Eric M Russell (2/25/2015)

---

A clustered key, a clustered Index, and a...

Eric M Russell (2/25/2015)

---

Of course a table can technically exist with no primary key, just like a feral child can...

GilaMonster (2/25/2015)

---

Not if you...

GilaMonster (2/25/2015)

---

PHYData DBA (2/25/2015)

---

What reliable business data will reporting from a Heap provide?

Not being sarcastic, just need to know to give you a good answer.

If a Heap is required then...

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

Grant Fritchey (2/19/2015)

---

shane.green 1227 (2/19/2015)

---

There are exceptions to every rule, so while "All tables should have at least one index" is good rule - it doesn't...

Jeff Moden (2/18/2015)

---

Guess I'll be one of the few dissenters here. Although it's a "best practice" to have clustered indexes on all permanent tables, remember that best practices are...

Luis Cazares (2/18/2015)

---

An experienced developer that likes to work with heaps in SQL Server is as good as a newbie.

I guess the correct option would be to prevent her on...

butcherking13 (2/18/2015)

---

I was hoping the tenured DBA’s would chime in on this. I work with a developer who has more experience as I am a very junior DBA. She is...

Thanks for this.

I had been looking for something that did not require access to the current trace file to show this data.