SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Coffee and SQL

I’m Carla Abanes, working as a full time Senior SQL Database Administrator here in Singapore for an established financial trading firm.

Archives: January 2014

Understanding CXPACKET wait stats in SQL Server

Understanding CXPACKET From the SQL BOL (Books on Line) CXPACKET is defined as Class Exchange Packet and “occurs when trying to synchronize the query processor exchange iterator. You may consider lowering the degree of parallelism if contention on this wait type becomes a problem.” To get a deeper understanding, it…

Read more

2 comments, 1,110 reads

Posted in Coffee and SQL on 21 January 2014

Understanding the Copy_Only option in Backups for SQL Server

The Copy_Only option is very useful in full backup scenario when you don’t want to break up the sequence of log sequence number in conventional SQL Server backups. For example, when you have a schedule of daily full backups and differential backup of every six hours daily. Then you need…

Read more

4 comments, 993 reads

Posted in Coffee and SQL on 8 January 2014

Reviewer #17 Database Replication in SQL Server 2012

Wow, my first article for the year 2014! Here’s to a blessed and fruitful year ahead for all of us <3 Database Replication  This topic is part 3 and the last topic of lesson in High Availability which covers 12% … Continue reading

Read more

0 comments, 602 reads

Posted in Coffee and SQL on 8 January 2014