Silverfox (9/10/2009)

---

Paul Monaghan (9/10/2009)

---

Hi,

At my current company I'm one of those 'involuntary DBAs'. Someone who has be thrust into the role as there was a need for it...any they didn't...

Active/Passive. If it turns out we have no choice but to dedicate new LUNs to the OCS instance, I'll probably change it to Active/Active (since it would be separately licensed,...

Check out the dmv sys.dm_db_index_usage_stats - that should give you pretty much exactly what you're looking for. Of course, you'll need to do some extra work to track down which...

GilaMonster (1/29/2009)

---

Matt Cherwin (1/28/2009)

---

The one bright side to this is it helps support my position that all SQL Server instances in the firm should at least fall under my purview...

Paul Randal (1/28/2009)

---

Yup - you're screwed. Without a backup to restore from, repair is your only option. If REPAIR_ALLOW_DATA_LOSS doesn't fix everything (it's not able to fix all corruptions) then...

Garadin (1/21/2009)

---

Decimal 8,2 means you have a total of 8 digits, not 8 to the left of the decimal point. Therefore, if you break a million (7 digits, you...

Check.

I've had this on hold for a little while now due to issues in production, but I'll probably have time this week to get back to it. I'll give it...

Grant Fritchey (9/10/2008)

---

It's not a huge deal to do this, but it will result in recompiles on the procedure since the execution plan for an UPDATE and one for an...

To answer the question, I have occasionally had the need to restore from backup via a UNC path across the LAN, and I haven't seen any issues. I have had...

Michael Valentine Jones (9/9/2008)

---

Michael Earl (9/9/2008)

---

I'm pretty glad as well.

The alternate universe in which two files could be in the same folder with the same name would be a very...

toparsi (9/9/2008)

---

Hello Guys,

I have a lot of databases to work with and need to keep track of all the changes. In my case, I need to copy backup files to...

What GSquared said, with one addition: in the SAN environments I've worked in, two LUNs with different RAID levels will automatically be on separate spindle sets. So, even if you've...

Sandra Skaar (9/9/2008)

---

I recently accepted a position as a DBA for a large company with many departments. This company never had a DBA and so I am up against some...

FILE is used to identify a file to include in the restore; I'm...

I had never heard of sys.dm_sql_referencing_entities before - that's fantastic. Thanks!