Browsing the blog archives for March, 2016

Table Info for Clustered Column Store Indexes

I’ve used a variation of this query for years and it worked pretty well, until clustered column store indexes came along. The general problem is that the column store indexes store the storage in LOB records, although data records are also included.  This resulted in the tables with column store clustered indexes having twice the […]

0 Comments

Identifying Netezza Backupsets

This is more a note to self than anything… Each week we run FULL backups against our databases, and write the backup files to disk.  In the past we kept the most current backup on disk for a week, and deleted it after the backups have been saved to tape. Then we start the cycle […]

0 Comments