eric.rini (7/29/2012)

---

Everyone knows usename and password is not enough. Stop blaming users for your flawed security implementations.

How about we stop reinventing the wheel and come up with a SAFE, SECURE,...

ldsudduth1 (7/29/2012)

---

Using a product to store passwordss for various sites is all well and good, but many of us have multiple devices (Laptop, desktop, smart phone, tablet). Our smart...

First, don't run stuff from the GUI. There is a "Script" button on all dialogs. Click that, get the code into SSMS in a query window, save it for log...

SQLRNNR (7/26/2012)

---

Lynn Pettis (7/26/2012)

---

SQLRNNR (7/26/2012)

---

Lynn Pettis (7/26/2012)

---

Did you take a close look at how Jeff's...

Succinct. I like it.

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...