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

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

Instant File Initialization–Do You Know It’s Value?

This weeks post by our US Senior PFE Susan Van Eyck is about the value of using Instant File Initialization. Lets have a look!   Be convinced of it’s value! This week’s Byte is about something the SQL Server world refers to as “Instant File Initialization” or IFI.  Interestingly, it’s not really a SQL Server…

0

Install SQL Server Books Online – Offline

Many of my customers run production environments which have never, and will never, be able to connect directly to the internet. They still have the desire to install Books Online (BOL) into those environments though, which leads up to this blog post – how do we do that? SQL 2012 & SQL 2014 For SQL…