Browse by Tags

SQL Server Upgrade - don't forget the Collation issues?
29 May 08 09:08 AM | ssqa.net | with no comments

Whenever any user (forum or usergroup) asks me about Upgrade gotchas and FAQs I will refer this SQLUpgrade-blurb post that I have made from my experience. Further I would like to enhance the topic of upgrade and things you need to watch about Collation...

Filed under: sql server, 2005, setup, collation, 2000, upgrade, settings, reference

SQL Server Integration Services - think about Transactions and Checkpointing?
07 April 08 07:21 AM | ssqa.net | with no comments

Transactions and Checkpoints are important factors for data consistency, when it comes for ETL processes that too on SSIS what is your stand? I'm covering this important task for the sake of newbie & junior DBAs, also the similar question was...

Filed under: sql server, best practices, ssis, setup, package, checkpoint, bol, commit, rollback, dts, ssis package, transaction

TSQL to change collation of database, whats new in SQL 2008 then?
12 March 08 08:10 AM | ssqa.net | 1 comment(s)

How can you change collation of a database? How do you check the existing collation setup on a database & tables? By using the below TSQL: --For database select databasepropertyex(db_name(),'collation') as collation_name go --Tables select column_name...

Filed under: sql server, database, tsql, table, change, indexes, setup, collation, installation, constraint, bcp