Love it.  Brilliant work.  So simple and effective.  I just tried this on one of my databases, and it's a solid performer.  I'm thinking of updating the algorithm to account...

Great article and technique.

How about dates stored in UTC? How do you configure the date table then? Do you create a date table that is also in UTC?...

wow, great tip, great write-up.

I ran this statement against a live, production database

select name,is_not_trusted from sys.foreign_keys

and it returned 57 untrusted foreign keys! Looks like I'll be making a script...

Not sure what the fuss is about. I've been installing just about every version of SQL from v6.5. Not just installing, but remote deployment and packaging with software...

I wrestled with this for quite awhile. I ended up doing a very manual thing. I blogged about it here

http://www.prd-software.com/blogs/entryid/60/importing-or-converting-microsoft-excel-data-into-sql-server.aspx

Hope it helps someone.

Rod

I'm a stickler for naming conventions on database objects. I am on a crusade to remove the information technology world of acronyms, and meaningless abbreviations - especially in the...

ApexSQL Script is the best for doing this type of this. Correct dependency order, scripting, custom tags + much more. Great product. Great support.

http://www.apexsql.com/sql_tools_script.asp

Rod