Archives: October 2010
What uses have you found for sparse columns in your databases?
SPARSE columns is a new feature in SQL Server 2008. This feature enables developers/DBAs or others who work with SQL Server database to store null values very effectively. In ideal scenario, if the column is NULL, than with this… Read more
In almost 12 weeks time, I’m embarking on a challenge of a lifetime. I’m scaling Africas highest peak, Mount Kilimanjaro to raise much needed funds for cancer research carried out at a local centre – Velindre (http://www.wales.nhs.uk/sites3/home.cfm?orgid=357)
I have started training and ventured up many of the finest… Read more
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is the process of moving data and database schema changes from one database to another server, either on the same server in different instances or on different server databases.
In… Read more