Hi. That is correct. A heap is a table with no clustered index....

Indy Mike (2/15/2016)

---

I've come to understand that tables below a certain size will not use the indexes assigned to them, because the table is more efficiently joined by loading it...

Yet Another DBA (10/27/2015)

---

ITIL works, chaos doesn't.

If you want to alienate either clients or business users ignore ITIL and just do releases any old how and never have a post-mortem...

And thanks for reading!

John.

Ray Herring (12/24/2015)

---

dbeggs57 (12/22/2015)

---

After reading just the first section "The Horror Begins", I thought you were talking about a Microsoft Dynamics application. With a slight bit of exaggeration added,...

blog 24112 (12/22/2015)

---

Nice story John. One I'm sure most of us that have been working in our field for longer than a few years can relate to.

I had a...

chudman (12/23/2015)

---

This happens quite often. It would be great to be able to go to a web page where the SQL DBA collective could review a list of...

Manic Star (12/22/2015)But but my report can't be 15 minutes behind , it must be *right now* data, so i, special snowflake, can't have my report that combs 15 years...

andycao (12/22/2015)

---

Accuracy? schamaracy. I have -- more than once -- found bugs in BI ETL Stored Procedures that were double (or triple) counting results, fixed the bugs, reloaded the...

skeleton567 (12/22/2015)

---

I sincerely wish I could hypothesize that a script failed to run somewhere in the installation, but my personal experience is that most current database systems are forced to...

Chris Harshman (12/22/2015)

---

hmm... I would be skeptically cautious about a database implemented completely in...

ephilipse (12/21/2015)

Off course it is rudimentary to have some form of trust to system engineers, but it is entirely different to hand-over access control to them. It would be out...

Hi.

If you...

Hi....

ephilipse (12/21/2015)

---

At itself an ok article.

However, in many situations the AD is beyond the control of the DBA, since it is part of system engineering, this would also hand-over authorisation...