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 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 … Continue reading
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 … Continue reading
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