The rotated 8 is a symbol for infinity. It means that you've defined a one-to-many relationship. That is, one person can have many clothes. But really, in a design of...

I remain where I was. Any of the hints can be useful in a given situation. My primary issue is when people see it as a general fix or best...

We keep track of every object in the database within source control.

Yeah, I've run into that one a few times too.

Neither. I prefer the granular control you get from writing your own backup methodology.

Yeah, keep your hands and feet inside the vehicle at all times.

From where I sit, NOLOCK is a crutch, not unlike DISTINCT, that can, in the short term, "fix" issues that are better approached by the hard slog of understanding how...

You can run multiple backups in parallel, but you'll want to monitor the system closely to be sure it doesn't badly impact performance.

Sure. Zip it up and attach it.

We go through the same worries about SANS all the time. You're completely dependent on your SAN admins to set up the drives appropriately and maintain them well. If your...

Oops. Serious egg on my face. That's new for 2008. It won't work with 2005. Sorry.

Gail's 100% correct.

I've got some 64 bit servers and I haven't seen this behavior, so I don't think it's the 64 bit alone that's causing the issue. Are there any...

Take a look at the services running on the server. Analysis Services, the OLAP engine, is completely different than SQL Server. That will till you which you have. However, you...

This is from BOL. I'd suggest trying it.

SELECT referencing_schema_name, referencing_entity_name, referencing_id, referencing_class_desc, is_caller_dependent

FROM sys.dm_sql_referencing_entities ('Production.Product', 'OBJECT');

First thing I see, do you reall need to do a left join to that sub-select. If I'm seeing the logic correctly, it's looking for any of the values that...