Very nice. Quick question, if there was only RID info (Node:1 RID: 8:1:231:0) in the deadlock entry could you still lookup the object info?

Quick question about the modify table section. Why does the tool need to create a new table when just making that small data type change? Could it just alter the...

Many times

moved up

Great thanks for the info everyone. Some additional details i've uncovered.

The consistency of the DB was always my concern. It looks like the backup/SAN vendors have a couple of...

Thanks for the info Carl. A few questions for you when you have a second.

1. Is the SAN replication configured as an incremental snapshot or a complete copy?

2. Does the...

Hello, I know this is an older posting but wondered how the SRDF - SQL server combo worked for you. We are considering the same architecture for a DR solution.

Brandie Tarvin (1/25/2008)

---

Since SELECT INTO doesn't usually copy over indexes and modifying the default file group before & after a SELECT INTO could cause major problems later on (what if...

Yes the select into...

I was thininking the DbMK will be in the mirror DB already.

I was under the impression that the only case when you don't need to do the backup-restore of the...

Adam Haines (11/27/2007)

---

No. You have the ability to do a point in time restore with all versions of SQL server, but the database must be set to full backup...

Michael Earl (11/27/2007)

---

The answer to your questions is basically "No". Even in simple recovery mode, MS SQL writes to the transaction log. In simple recovery mode, it just...

Thanks for the info. Yes, thats a very good point. I wasted some time last week on this point. On this occasion I did take a full backup before my...

aspersage (10/29/2007)

---

Anyway, one of the dba's on our team is blaming the SAN, saying that because we are using write and read cache on the SAN, that the transaction is...

I like both but I do have to say that with enterprise class systems (8CPUs +) the scalability of SQL Server could become a problem. I would love to hear...