UDF Performance Issues

Excellent post by MVP Gail Shaw on how user defined functions can hurt performance by introducing row-by-row processing.

http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/

r

Off-Topic : Rockbox

Have given an old Iriver H340 a new lease of life with new firmware...


http://www.rockbox.org/

(Highly recommended)

Free Scrum Reference Card

http://refcardz.dzone.com/refcardz/scrum

Windows 7 : Release Candidate

Is out tomorrow apparently...

http://www.vnunet.com/vnunet/news/2241098/windows-rc-release-date

Off-topic : Windows Mobile 5.0 - Deleting all Text Messages

Had too many and it slowed right down.
The option to delete them all is there (but hidden)...

http://msmobiles.com/news.php/3851.html

Language Support in Management Studio

Had a mad moment today trying to work out why a colleague could see characters from eastern languages in Management Studio and I could not.

Turns out the setting is machine based and located in Control Panel (Regional & Language Options), not Management Studio itself...

SQL 2008 : Backup Compression Default

Set server option to turn on sql 2008 backup compression by default...

USE master;
GO
EXEC sp_configure 'backup compression default', '1';
GO
RECONFIGURE WITH OVERRIDE;
GO