Without knowing more about your server, database, how and by whom it is used, this post is a long shot but I'm going to post it just in case it...

HB,

I appreciate your response and ideas. I am not keen on losing data either.

We could take 1 full backup per day, then differential backups every 2 hours, and in...

homebrew01 (5/1/2011)

---

crainlee2 (5/1/2011)

---

Craig,

We decided not to implement point-in-time recovery. Business requirements dictated that being up and online was more important than some data loss, so we use the Simple Recovery...

Craig,

No, we don't use the SAN to avoid standard database backups using SQL Server. We do both SAN replays and SQL Server backups for the purpose of intentional redundancy, in...

Thanks for your response.

I hadn't considered the time penalty for executing almost 5000 row locks.

LC

Craig Farrell (4/29/2011)

---

You mention you use simple backups. If you have full backups and need point in time restoration capability, can compellent's snapshots deal with this? I'm assuming...

David Egnoski (4/21/2011)

---

Our network folks are using Compellent Storage Center for their file backups and DR. They are pushing to have us abandon Redgate for SQL backups and go...

yentha.valla (4/27/2011)

---

HI,

Thanks for prompt reply ..

MA new to Sql Server .. Now i hv to do Performance tuning on Database .. i was working as Oracle DBA .. in our...

Jeff,

I looked at your Delete Crawler. I've implemented a job similar to it but a little different, and I'd like to know if I've missed something or have neglected to...

Steve,

I've encountered many business scenarios where a DBA is the last employee considered for hiring. The primary reason, from what I've experienced, is that many managers and software engineers simply...

Nice photo in your editorial, Steve.

I remember when tape drives like the one in your photo were state of the art. Disk drives had just begun to make their...

lianvh (4/15/2011)

---

Good Day ,

We deployed Online Indexing on SQLS erver 2005 Enterprise Edition . I was rather disapppointed when I noticed that this caused locks on the system and a...

David,

I saw and had similar experiences when I worked at FedEx.

FedEx is a Fortune 70 international company with many thousands of servers all over the planet. FedEx I.T. employees...

lianvh,

I have posted some solutions to online indexing problems I've faced and solved, including the context of the problems and the solutions.

Have my ideas and/or solutions been helpful? Do you...

After decades of work in the business world, I have found that old habits die hard.

I remember when men (programmers) had to wear long sleeve white shirts and ties...