nlion84DBA (4/21/2014)

---

Our shop is has taken virtualization to almost an extreme. The VMWare team has modified configuration files so they can build a SQL Server from the ground up...

Eric M Russell (4/21/2014)

---

In addition to the general advice "never stop learning", another piece of advice is "never stop browsing the job posting sites". The career advice dispensed by your...

Thanks.

When I was 12, I still wanted to be in law enforcement of some sort, though I had...

This might help. Not sure if it's exactly what you need, but if it's running, this can determine some information: http://blogs.msdn.com/b/taylaf/archive/2010/01/25/determine-the-currently-executing-statement-in-a-long-running-sql-stored-procedure.aspx

If you have a trace or eventing set up, I...

Greg Edwards-268690 (4/19/2014)

---

Steve -

Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that...

There's a lot to this.

First, encryption. I'd do the encryption on the data load. If not, then potentially you are storing data that compromises your security. You can create...

Encrypted data needs to be stored as varbinary. You cannot also store the decrypted value.

However, if you also store the decrypted value, there's arguably no reason for you to encrypt...

It's yours and thanks.

If an index is used: http://blog.sqlauthority.com/2008/10/03/sql-server-2008-find-if-index-is-being-used-in-database/

You can tell, but restarts will clear your stats.

There's also a good piece from Kimberly Tripp on duplicate indexes that's worth reading.

FWIW, I'd make sure...

there are a few links here to help you, but let me ask you this. How would you do this without SQL? What is the algorithm you'd use?

Once you have...

I'd do as Lutz suggested.

As a side note, never commit changes in the Table Designer. It makes it easy to change things, add indexes, set primary keys, etc, and I...

rodjkidd (4/17/2014)

---

Greg Edwards-268690 (4/16/2014)

---

WayneS (4/16/2014)

---

Steve Jones - SSC Editor (4/16/2014)

---

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no...

WayneS (4/16/2014)

---

Steve Jones - SSC Editor (4/16/2014)

---

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips scheduled and...

Divine Flame (4/17/2014)

---

Steve\Gail,

I have written something on it. I may submit it today. You can check if it is good to publish.

P.S.: Like everybody else on SSC, I would always...

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips scheduled and no speaking commitments in the future.

😀