are you member of the db-ower db group or sysadmin at the production instance ?

It is a best practice to have tempdb on its own drive(s).

Yes it is for performance. (cfr like you would separate page files from C-drive)

Keep in mind: every instance user...

are you using a maintenance plan for this ?

If yes, upgrade to at least Cumulative Update 2 for sp2 (current is CU10, sp3 is in beta.)

Very good summary.

I hope I'll get another chance next year.

PASS is always a hard week because...

just my 2ct to add to the previous replies....

- double check the nic cables to see if the connectores are fixed.

- check for hardware firmware know issues and upgrade if...

Once again a statement that makes 100% sense.

"Let the first one without sin throw the first rock."

Few rocks will be thrown:Whistling:

Arthur.Lorenzini (11/20/2008)

---

It needs to fetch extra datapages to get cd.salesman_employee_id.

If you comment it out, it will solve the query index only for table customer_detail.

How up to date are your statistics...

DBASkippack (11/20/2008)

---

[font="Courier New"]I successfullybacked up my DB to 4 seperate files:

BACKUP DATABASE MyDB TO DISK =

'D:\MyDB_01of04.bak',DISK='D:\MyDB_02of04.bak', DISK='D:\MyDB_03of04.bak', DISK='D:\MyDB_04of04.bak' WITH INIT, NOFORMAT

Unfortunately, my RESTE IS NOT WORKING. I...

randy.witt (11/20/2008)

---

One of our software vendors says that we need to have Cumulative Update 7 installed, before we upgrade their software with the newest update. When I go to...

very good info.

Thanks

Johan

I see you did discover the dbmail helper objects 😉

- Does it succeed if you use a vbs to send mail using that smtp server ?

- double check the port...

if you would use included column, the B-tree part of the index would be smaller, so faster.

I should have to test, if SQLserver still would resolve the filtering based on...

Is your SQL2000 db comming from a sql2000 version that is supported for upgrade (i.e. >= SQL2000 SP4) ?

Arch ... formatted exports...