How often, every day, every hour, real time?  How much data? Can you give a more detailed description of what you want to accomplish?

As always, there is a fine balance between standards/guidelines and the overhead of having to enforce them.  I found these helpfull:

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

http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLServerDatabases.aspx

http://msdn.microsoft.com/practices/

Run SQLdiag.exe and look in the [System Summary] section.

So, as data is entered into one database, it needs to be immediately available in the second database?  If so, have you considered having the CREP database just reference the...

Can you give a little more info on what you are trying to do?  Do you need a one-time transfer, a routine transfer, real time syncronization?  What does the table structure look like between...

A table level lock is a natural event and is part of the SQL Server locking architecture.  There are many articles on this site devoted to locking, so I'll just...

Changing the datatype from char to varchar will reduce the amount of space each row of data in that table will require for storage.  Datatype Char reserves a set amount...

Personally, I would say no.  As I said in my first post, you will get more bang for your buck regularly keeping on top of SQL Server fragmentation by rebuilding...

If you are using the Windows defrag tool, you definately do not want to run it during business hours.  For one, like Brian pointed out, you will see increased I/O,...

I thought you were running this through a stored procedure??  If so, run your stored procedure outside of ColdFusion so that you can debug your code.  Once your code works,...

What you are proposing should work.  Are you getting an error message back from your second example?

This may help, but then again, it may not:

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

NewTechie,  

You will be better served by placing your request in it's own thread. 

Have you created the format file NewProspectJoJo.fmt in E:\WUTemp?

When you say that you are using a defragmenter, do you mean that you have a third party tool that will defragment your MDF and LDF files?  If so, I...