I understand. Thanks

Sean Lange (9/22/2011)

---

Given the inability to do this via RI it looks like what you posted originally should work fine. The painful limitation of course is that it can only...

Steve Jones - SSC Editor (9/26/2011)

---

Nothing I know of. Most companies I've worked on have had 2 or 3 schemes they used (often for dbs in full and simple), but...

Steve Jones - SSC Editor (9/26/2011)

---

The problem with documentation is that it will perpetually be out of date. And at the point that you need to reference something is when...

Steve Jones - SSC Editor (9/26/2011)

---

What do you mean by document? Or what do you need?

I've done a few things. First, always name the backup for the database, type, and...

This is a databvase created/used by an accounting application we use. We didn't create it and so we...

No sooner then I replied back about relocating tempdb to its own drive I remembered that I had already done this last month. I know that sounds bad at first...

Jeff Moden (9/9/2011)

---

Just remember that in a SAN envirionment, separate drive letters don't necessarily equate to separate spindles. Check with the folks managing your hard disk storage space to...

GilaMonster (9/9/2011)

---

Jeff Moden (9/9/2011)

---

Gail is the expert in this area but I believe the next thing I'd move is TempDB. If that's already on separate physical spindles, then maybe...

GilaMonster (8/4/2011)

---

YSLGuru (8/3/2011)

---

BTW - I've always wanted to ask if your avatar is one of the chaarcters from the short lived Babylon 5 spin off? I forget the show...

I swear I did not...

Sean Lange (8/18/2011)

---

Glad you solved your issue but you could use a nested replace instead of a scalar function in this case to produce the same results.

declare @MyVal varchar(50) =...

Grant Fritchey (8/25/2011)

---

A CTE is a derived table. So, saying which one is faster or not, is not really possible per se. It depends on how they're put together, how...

Evil Kraig F (9/8/2011)

---

Find the largest and hardest hit tables, and try to split them from join to join across two filegroups on the different drives. This way you...

Thanks Gail and I woudl certainly do that first but the llg file already is on its own drive. I negelcted to say that in my...