Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2010

Why do you use Sparse Columns ? (by Abi Chapagai)

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

0 comments, 1,218 reads

Posted in DatabaseExpertise.com on 31 October 2010

Training begins in earnest !

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

1 comments, 167 reads

Posted in DatabaseExpertise.com on 19 October 2010

Transactional Replication Setup (by Abi Chapagai)

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

11 comments, 7,407 reads

Posted in DatabaseExpertise.com on 3 October 2010