The database master key is itself a symmetric key. Assymetric keys provide increased security, the symmetric key is purely used to protect the main (or Assymetric key) while it is...

you can also use xp_regread to query the apprpriate registry values for your SQL server instance.

The LSNs and hence restore points will be completely different between databases, it would make...

mahesh.dasoni (11/24/2012)

---

We have SQl Server 2005 Standard edition which was Intially on another domain at that time it was working fine.

Now when it been moved to another domain we are...

SQL_ME_RICH (11/21/2012)

---

Recently, my applications architect decided that we needed to change the level of the database Isolation from the the default READ COMMITTED to SNAPSHOT ISOLATION (basically Read Committed with...

sanath.kumar.kura (11/26/2012)

---

Hi All,

The log file is grown to five times the database size.

Transaction Log file size 3.1GB

Database file size is 700 MB

Recovery Model : Full

backup strategy : Daily full database...

Yes, of course the databases will be totally...

Follow my guide at these links

Part 1[/url]

Part 2[/url]

Part 3[/url]

Can you provide more details around your mirror setup?

What do you mean corrupted?

What are you doing to get the principal back online?

The differences between RAID 1+0 and 0+1 are not academic. Let's just review that again, not academic!!!

If you do decide to deploy a 0+1 array for your mission critical data...

Sqlsavy (11/23/2012)

---

Hi All,

We use Litespeed to backup our databases. One particular database grows 330MB/day there is enough space on the data and log drives but I think backup drive will...

you never considered raising the Cost threshold for parallelism instead?

:w00t:

:w00t:

:w00t:

??

Why dont you just...

TheSQLGuru (11/21/2012)

---

I would like to add to this thread that the number of clients I have had in 15 years of consulting that actually had tempdb allocation issues is TWO,...

Standard only supports full safety, this translates into synchronous mode

😉