OK, so… I don't know how many of you use different collations but if you do then you know that there are two truths: 1) They're very flexible 2) They can cause you a bit of grief (changing collations and tempdb) Flexibility As of SQL Server 2000 (or heck, maybe it was 7.0?), database collations [...]
Kimberly L. Tripp
Improving my SQL skills through your questions!
Changing Database Collation and dealing with TempDB Objects
Posted on: May 30, 2006 2:31 pm
Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB
Posted on: September 5, 2005 6:28 pm
This is a much needed and much overdue blog entry… In 8 Steps to Better Transaction Log throughput, I mentioned a customer that was helped by TWO typical optimization problems I see. In that blog entry, I said I would write two blog entries – that one on transaction log optimization and another on common [...]
