September 2009 - Posts

24 September 2009
Backup compression on SQL 2005
Last night, after a lot of preparation, I finally flicked the switch on the backup compression solution I've been implementing. The results were dramatic but in a good way: backup jobs 60% faster 50% disk space saving Reporting & BI build 30% faster Reporting & BI ready 3 hours earlier than... Read More...
no comments
Filed under: ,
18 September 2009
Column length in SQL 2005 Analysis Services cube
I've been dark for a while as I've been on holiday in Turkey on the 'Tourqoise Coast'. Great people, hot and sunny, amazing diving water, thoroughly recommended. Anyway. I had a new one today with a cube. A few weeks ago, in the underlying database, a varchar column's max length was... Read More...
no comments
Filed under: