Not without testing them to make sure they really do help.

Huh?

Do you really have a directory called E:\as.mdf\? Not a file, a directory?

That'll work initially, however as someone with control server...

Encryption (with the keys stored outside the DB) is about the only way to do this. If a DBA has sysadmin permissions then, by definition, he can do absolutely anything...

Try a google search. Should turn something up.

amitsingh308 (11/13/2009)

---

ya i know that but I want to know that after hashing the data how databse operate it because if we are encrypting password of a user then how...

Hashing is typically a one-way operation. ie the original data cannot be obtained from the hashed value.

Looks like the clustered index is about as good as you're going to get here. Query needs a few too many columns for a covering nonclustered index to be a...

The time for that select * is probably a combination of time to get the data off disk and time to get it across the network. Why are you querying...

Bulk insert, bcp and SELECT INTO are all minimally logged if the database's recovery model is something other than FULL. There are other limitations, check Books Online for the details...

How was the data put into the 'hashed' form?

Roust_m (11/12/2009)

---

the second one, I am not sure 100%, but the clustered index only has that identity column which does not get updated.

Would the data updates affect clustered...

Restore with recovery?

Depends what you want to do with the DB. If you're restoring additional backups, then you need to...

That doesn't look like a valid filename to me. Double check what it is that you're setting...

Same as T-SQL functions.