Ever wondered SQL Server Data Importing Do's and Don'ts, with a set of best practices. Import of data is a common task in any database platform and when it becomes regular you have to take care lot of incompatibilities. In particular SQL Server DBAs often find themselves importing and massaging data using T-SQL. Why? Because some transformations of the data simply require the power of full-fledged SQL. Having just recently survived yet another case of data importing, I was inspired to assemble a...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/10/26/sql-essentials-sql-server-data-importing-do-s-and-don-ts.aspx