FYI :

http://www.simple-talk.com/community/blogs/tony_davis/archive/2008/11/25/70602.aspx

http://www.simple-talk.com/sql/t-sql-programming/unique-experiences!/

Coyote Blue (11/26/2008)

My 2cents: Make sure it is actually a physically separate drive, and not just a drive partition on the same physical drive. My experience has been that you...

This may clarify a bit regarding surrogate keys:

http://www.intelligententerprise.com/channels/business_intelligence/showArticle.jhtml?articleID=201806814

I guess we all need to do what I did today .... have a day off :w00t:

I followed a "refresh" day of CPR for human victims this time.

It cleared the...

You can change min and max whilst your instance is online.

You'll see its actual impact after issuing a system checkpoint.

but if you're going to use maint plans, apply at least CU2 (current = CU10 and sp3 is in public beta)

For the moment we apply CU10 for new installations. (didn't...

- try to keep a primary key column meaningless, you'll not have to modify (datatype/length) it during the lifetime of the database. (var)Char always tend to get meaningfull after a...

well .... Kalen has great info on it ...

http://sqlblog.com/blogs/kalen_delaney/archive/2008/11/24/change-a-column-in-an-index-from-a-key-column-to-an-included-column.aspx

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