SQL Clone
SQLServerCentral is supported by Redgate
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, 2,337 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, 417 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

12 comments, 11,610 reads

Posted in DatabaseExpertise.com on 3 October 2010