another reason to avoid functions as much as possible.

In many cases they can be replaced by another form of joins and that explicitely point to one of the biggest dangers...

Rubbish in .... rubbish out :unsure:

As in many cases, providing exactly what you need may get your problem(s) solved much...

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