Matt Miller (#4) (7/26/2012)

---

While I'm sure that there are other reasons - here are a few:

- a heap's nonclustered indexing relies on a "heap row ID", which is basically...

How did you run the shrink process?

insert log select getdate()

dbcc shrinkfile

insert log select getdate()

will do it.

Please don't cross post or duplicate post.

script, script, script.

Get a process inline that

- moves a full backup from instance A -> B

- restore this on instance B

- if this takes a long time, make a...

derek.colley (7/26/2012)

---

Sorry Abel but this is god-awful advice. I recently got involved in a round of...

SpringTownDBA (7/26/2012)

---

Ok, I understand what you're describing.

If the VM host is ONLY going to host 1 VM EVER, then what is the value added by vmware? It's...

Michael Valentine Jones (7/26/2012)

---

Putting an artificial and unneeded CPU load on a server, putting large files that are not needed on the disk, and generating unneeded disk or network IO...

TravisDBA (7/26/2012)

---

"I'm not sure how I'd want this to work on my SQL Servers. After all, any load I placed on them wouldn't necessarily just occupy CPU. It would also...

Excellent

🙂

SpringTownDBA (7/25/2012)

---

...

As for a VM vs physical HW, you need to understand how balloon drivers work, how sql server memory allocations work, how sql server gives memory back to the...

+1

Don't ever build a process to shrink data or log files. Manage them appropriately. The space you need today may be too small for tomorrow, so don't have a process...

To be clear, I don't mind the reporting posts, even if the reports are false positives. The issue is with Mr. Celko's behavior.

You can also talk to friends, and ask them to ask their friends. Or look on LinkedIn and cold message some people that fit your needs. Recruiters do that, no...

Vikrant S Patil (7/25/2012)

---

The significant thing to consider is that Third party tools may use mutithreading ( they generally do) and add to the CPU overhead. Also Third party backup...