Category Archives: SQL
Tool for changing SQL Server database collation
Changing the collation of a database and all objects in it cannot be easily done using SQL Server Management Studio (as far as I know).I found this tool that does all that, and it works on SQL Server 2000, 2005 and 2008. http://www.codeproject.com/KB/database/ChangeCollation.aspx … Continue reading
Posted in SQL
Leave a comment
Top 10 steps to optimize data access in SQL Server
Found this great 3-series article on how to optimize data access in SQL Server on codeproject; http://www.codeproject.com/KB/database/RefactorTSQLs.aspx
Posted in SQL
Leave a comment
Tore Senneseth 