For some reason Web and App developers with no DB experience seem to beleive a Myth about database systems being intelligent and no tuning is required. Where the hell...

Watch out for embedded carriage returns, tabs, etc...

RTRIM(LTRIM()) and REPLACE(string,' ','') will not clean it all up.

I don't have the full list at hand, mine is an Oracle version.

Obvious ones...

BTW, the only other thing I changed in the dowloaded package was setting the MaximumErrorCount to 99. I ended up adding a bunch of servers and instances that...

David, Thanks for the cool tool. I look forward to parts II and III.

BTW, if you can not see the variables in the list, right click on the designer surface and click variables. I downloaded the zip and SVR_Conn did not show...

If you have not, try setting the default value for the SVR_Conn variable to (local) or to your server name \ instance name . That worked for me. ...

OK, now that we have picked on Oracle let's point out a few of its good or unique features.

1. Spatial data is an interesting feature hardly anybody uses. Storing...

Also, in my experiences I've only seen DB2 used in production where old IBM mainframes are found somewhere in the building or attached to the network. We dumped support...

Keep in mind that the Windows platform is not Oracle's main focus. UNIX platforms almost always get patches or bug fixes before the Windows platform. I'm always told...

I have 500 customers running their own SQL Server with our products database installed on their server. The DB is theirs and they have to do all of the...

Compressing the files before transferring on a slower network also helps.

You could generate insert statements of your data and run those against your other DBs.

Try:

select 'insert into temp_table_name values (''' + column_value + ''')' from source_table

You will need to address...

I admit I'm a DBA/Developer for an ISV and support internal systems and 500 customers running SQL 6.5 - 2005 and Oracle 8 - 10. So by habit I...

How do you find the duplicate rows in a table with Integer ID and a varchar name fields?

select * from [table_name] a where

[varchar column] in (select [varchar column], count(*)...