I recently evaluated using page compression on some of my production data (see my post on estimating data compression). I’m using transactional replication to send this data out to a few other servers for reporting purposes and I wanted to adjust replication so that the data compression settings on the tables would also be replicated.…
Tag: T-SQL
What Indexes Are Not Being Used And How Big Are They?
Leafs Stanley Cup Cabinet (or Cubs World Series Trophy Cabinet)Indexes…they are your friends. They order your data nice and neatly, they can dramatically improve your query performance and can have cool names like IX_UseMeToRunFasterLikeATurboButton. Indexes…they are your enemy. They slow down your inserts, updates and deletes, and they take up valuable disk space. So having…