This might give you a start:

http://www.sql-server-performance.com/query_execution_plan_analysis.asp

You can set your recovery model to bulk-logged during import. That way only the fact is recorded in the log, not each simgle operation. Right after the import, you can...

On your error handling question, you might want to read this:

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-I.html

Create a view on getdate() and use it in the function.

Be careful with this advise!

See http://www.insidesql.de/content/view/100/ on what can happen.

scnr

Hey, sounds really good.

We should think of starting some "classic" off-topic threads again.

Did you already try DBCC CHECKTABLE?

That times are gone!

http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/catid,1/

( if you don't mind, Adam)

You need to scroll down a bit.

Sounds like a good idea. And while you're at it, please take also care of these:

sp_MShelpcolumns

sp_MStablekeys

sp_MStablechecks

sp_MShelpindex

sp_MShelpfulltextscript

sp_MSobjectprivs

I would like a copy

Please don't cross post. Leave the answers here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=145361

Nice one. However I am missing a statement somewhere that your script makes calls to undocumented (=unsupported) procedures. You should be able to achieve the same using the documented sp_fkeys...

Okay, I think you have a logical error here. It seems that you call the sp which sets the IDENTITY_INSERT to on. And then do the INSERT, but not inside...

You might be better off asking such question to merely Oracle related sites such as

http://asktom.oracle.com/pls/ask/f?p=4950:1:5641538977840182319:RESET::1 or

http://www.orafaq.com/

You can find it also explained here http://www.sqldts.com/default.aspx?212 along with a wrapper procedure to change multiple packages at a time.

Patrick,

long time no see. When I look at your postcount, it...

However, a PK (composite or not) is created as a clustered index by default in EM - unless you have already defined another index on the table as clustered.

Well, not...