While searching through google for performance tips on SSIS / DTS 2005, I came across Ashvini Sharma’s blog. There’s a number of great entries dealing with package execution and ways you can improve your throughput. Checkout the entry on DefaultBufferMaxRows and DefaultBufferSize.
COLLATE Keyword used to define string collation used for a database, column or server. Can also be used to cast the collation of a column or variable when used in a t-sql expression. SQL Server 2000 and SQL Server 2005 allow you to use Windows Collation Names or SQL Collation Names. To see a list […]
If you’ve ever worked with databases from different sources, or with different collation settings, you’ve probably encountered an error like this: Msg 468, Level 16, State 9, Line 1 Cannot resolve collation conflict between ‘Latin1_General_CI_AS’ and ‘SQL_Latin1_General_CP1_CI_AS’ in equal to operation. The error is cause by having different collation settings for the columns in the […]
One of the tasks regularly performed in ETL processes is using BCP or BULK INSERT to import large amounts of data into a empty database. You might be using these tools to import a single file into a table, or many files into a table. Either way, SQL Server is going to want to update […]