Thanks Paul for clarifying.

TheSQLGuru (12/12/2009)

---

Curious. I wonder if that improvement came simply because NetApp was doing something 'dumb' with the RAID 5 setup you had. I have heard horror stories from...

Christian Buettner-167247 (12/14/2009)

---

Hm, is someone able to explain this?

Same code as before, but positioned order by (1 instead of i) and "-" as separator for better readability.

SET NOCOUNT ON

create table...

LOL

BEAR

Alvin Ramard (12/14/2009)

---

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be...

GSquared (12/14/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be mine (or...

SQLAGENT$SQLSERVERVIEW is The SQL Agent Service that controls your SQL Jobs. Since your 3rd party app relies on some jobs to keep DB trimmed and cleaned out, you should...

Doh - version based question where the results change.

SSMS 2005 and 2008 both gave me 3.4

If you find that you need to compare rowsets to verify that data truly is in sync, then a third party tool like Steve suggested would be ideal.

The default will depend on your server configurations. If your model DB is set to full recovery - then you will get full recovery when you install your DB.

As...

Chan Wai Yin (12/13/2009)

---

CirquedeSQLeil (12/12/2009)

---

What recovery model are you using?

If full, you should do a full db backup and then schedule transaction log backups.

Once the transaction log has been backed...

Jeff Moden (12/13/2009)

---

Matt Miller (#4) (12/13/2009)

---

Oh - were...

Pandora

GilaMonster (12/13/2009)

---

I saw the preview for that. Brought back some memories. I...