Jack Corbett (7/6/2009)

---

The Optimizer uses statistics to determine if a seek or a scan is the likely "best" access method for a given query. It actually takes a very...

Time to switch...

GSquared (6/30/2009)

---

I read and mostly understood Frank Herbert's "Dune" when I was...

WayneS (6/29/2009)

---

Hey gang... I'm looking to take "She who must be obeyed" (in this case, both my wife and mother... ) to Niagra Falls. Does anyone here know anything about...

Regarding the Nth Normal Form, and I guess on a more philosophical level, is it true that the more normalized a database is, the less fragmentation occurs so the more...

GSquared (6/29/2009)

---

GilaMonster (6/28/2009)

---

Lynn Pettis (6/27/2009)

---

Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was in when I had...

Steve Jones - Editor (6/26/2009)

---

I agree with Gaby. The day your backup fails is likely the same day your disk array will fail. Don't play around. Make sure these work...

If you absolutely must backup remotely, use a third party backup utility (we use Litespeed from Quest, but SQL Backup Pro from Redgate is also good). The backup is...

Double-checking a solution suggested by the more seasoned gurus on this or other sites is perfectly fine. If I run it on my own desktop, and it doesn't work,...

GilaMonster (6/23/2009)

---

...As to whether a DBA needs to know normalisation or not depends on their job. If all they're doing is backups, watching space and monitoring jobs, then no they...

GilaMonster (6/18/2009)

---

jordonpilling (6/18/2009)

---

Now, I have a weekly Index rebuild task which may be bloating the log file considerably as you say. What I will do then is, alter my Weekly...

GilaMonster (6/22/2009)

---

That's one...

Grant Fritchey (6/19/2009)

---

Matt Miller (6/18/2009)

---

I like your questions Grant. I usually just add in one more, it's actually usually my first (fail is and it's time to call it...

We've finally gotten serious about updating a whole bunch of our production servers (mainly SQL 2000, SQL 2005 seem to be up to date). But the scary thing is...

Steve Jones - Editor (6/17/2009)

---

The order of the SELECTs shouldn't matter, AFAIK. The query optimizer is supposed to know what is where in a partitioned view and not query those...