Roy Ernest (1/19/2009)

---

You can look up Encryption on BOL. That would be the best. Or let your App handle the encryption and save the encrypted data in the password Field....

Eric Klovning (1/18/2009)

---

I would be hesitant to try the following since there is the potential to do quite a bit of damage but I thought I might mention you could...

John Rowan (1/9/2009)

---

You may consider looking to see if the vendor includes any sort of 'DateCreated' type column in their tables. I've found that using a create date column...

No, it looks like all databases only go back 3 months on 2 of 5 servers. I can't remember any event on both servers from that time that would have...

Perry Whittle (1/10/2009)

---

homebrew01 (1/10/2009)

---

Our plan is to take our 2 heaviest hit SQL servers and put them onto their own physical machines running VM. They will have the VM overhead,...

John Beggs (1/8/2009)

---

@homebrew01 -- Any differences in data dispersement over your physical disks is based upon the software controlling the solution, not the access method. Neither iSCSI or FC-AL...

Jonathan Kehayias (1/8/2009)

---

I've done...

colin Leversuch-Roberts (1/8/2009)

---

Yeah I'm not very popular with a certain vendor currently - I'm off to scale some big databases, maybe around 100TB so should get to grips with some...

Run this to find all the Data & Log files currently in use:

exec sp_MSforeachdb 'Select ''?'' as DB_Name, * from ?.dbo.Sysfiles'

Then scan your drives for .MDF, .NDF and .LDF files...

ISCSI vs Fibre Channel. We're setting up a VM environment, and the Dell rep told me that with the ISCSI SAN, the LUNs are automatically spread across all the...

I don't think there is a way unless you had a trace running or a 3rd party tool such a Compliance Manager.

Jeffrey Williams (1/2/2009)

---

Why do you think you don't have a clustered index? I would take another look at the table - because your results are telling you that you...

Nicholas Cain (1/2/2009)

---

You've got a primary key, why not put a clustered index on it?

Anyhow, try removing the WITH FAST option and see if you get different results. Per BOL...

Many of us prefer to backup to local disk, then copy the flat file to tape later. Faster & more reliable

For some reason the application that we bought does not use clustered indexes. Most of the non-clustered have been moved to the other file group on G.

Some unique primary key...