Fill Factor and Data Compression

Another post by our excellent US PFE Susan Van Eyck goes though Fill Factor and Data Compression!   I got a pair of interesting questions from a colleague this week: If you’re using fill factor then enable data compression, is the fill factor still enforced? If you aren’t using fill factor and enable data compression…

2

Microseconds Or Milliseconds

  While working with a customer on creating some Extended Event to collect performance trace, I was if asked if the duration is in microseconds or milliseconds. Thinking to myself, “well in SQL 2005 and later it is in microseconds”, although the Profiler UI has an option to display the value in either milliseconds or microseconds. …

0

You really need to look out for msdb security

So msdb, we don’t really think about it that much right? We know it holds the metadata for our Jobs and Schedules, also some good info on page corruptions, as well as backups, and much more. But how often do we think about it’s security? You may already know that the Guest user is enabled…


Troubleshooting Using Ring Buffers

Working at a customer site, and I happened to notice that the Exception ring buffer contained a lot (and I mean A.L.O.T.) of errors. Ring Buffers were introduced in SQL 2008, and contain a fixed size cycle of records for the ring buffer they pertain to. Now… note – sys.dm_os_ring_buffers is a DMV which is…


Advantages and Annoyances of Filtered Indexes

This weeks great post by our US Senior PFE Susan Van Eyck talks about the wonders of filtered indexes! Check it out!   Today’s Byte is about the advantages and annoyances of filtered indexes.  We’ll talk about What they are Where (and why) they’re useful How to create one How to convince the optimizer to…

0