ALZDBA (11/27/2008)

---

Coyote Blue (11/26/2008)

---

...

My 2cents: Make sure it is actually a physically separate drive, and not just a drive partition on the same physical drive. My experience has been that...

2 Tim 3:16 (11/26/2008)

---

While placing the TemDB on a separate drive is a "best practice", it's not an automatic to do. It all depends on your application. Is...

thanks B!

(all this casting for a sql solution? I feel like a fisherman! haha I slay me....):crazy:

Coyote Blue (11/20/2008)

---

Closer to what I was expecting; but the rounding still seems *wrong* to me (and I am an 'untrained' dba picking this up as I go along....)

does...

Closer to what I was expecting; but the rounding still seems *wrong* to me (and I am an 'untrained' dba picking this up as I go along....)

does it round...

GSquared (8/29/2008)

---

I run checkDB before I do backups. Can't see the point to backing up a corrupted file.

No reason to update stats before/after an index rebuild, since it does...

Junior_DBA (8/10/2008)

---

Hi All,

I have problems trying to fix a warning windows over my SSMS each time I open it.

I made an upgrade from Windows Server 2003 Standard Edition to Enterprise...

GSquared (8/8/2008)

---

I'm still learning new things nearly every day, and...

Mike Menser (4/4/2008)

---

I was reading a database magazine this morning and it had an interesting question. They were going to take a poll to see which group of DBA's were...

Still learning SQL -- consider myself a newbie still after 2 yrs becuase I am still learning new things every day -- but I found ; for me and my...

My two cents; bcuz I used to have to manage the Disaster Recovery Handbook for my last employer (and this is not just for DB recovery...)

"Your Data Backup is...

I guess all we can do as techno geeks (or as a person from another biz group in my company calls us, but they refuse to put it on my...

Be very glad it is not a SQL7 cluster... I had to un-install SQL7 from a cluster (remotely) and after 8 hrs on the phone with MS tech; with no...

Dunno if this is resolved yet but...

Is this mssql2005 or mssql2000?

I am guessing this db is hosted remote;;; and there is some configurations you have to go through in mssql2005...

I did the SAME THING... 'hmm,,, looks like two are wrong ... but which is MORE wrong...' :pinch:

And I am relatively new to tsql; only been doing 'hard' sql in...