can you post the full create database statement for that database on pre-prod and on prod ?

i.e. the create statement and all the following alter database statements

rbarryyoung (11/24/2008)

---

Jonathan Kehayias (11/24/2008)

---

Hmmmm, how about...

That only means you haven't got Books Online installed on your pc.

No problem. You can find it online at http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx

Congratulations Jonathan !

I'm just popping a first glimps.

Why should a function that only returns a fixed date, return a NULL value if the input is null and the input is not checked.

Correct...

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...