By May 19, 2015 0 Comments Read More →

The Case for Optimize for Ad Hoc Workloads

I recently was involved in a discussion about whether or not to enable the ‘Optimize for Ad Hoc Workloads’ server configuration setting.  My initial thought was to leave it disabled, since this is the default after all, and we didn’t have a specific situation where it was believed enabling this would have helped.  I admittedly did not know […]

By May 12, 2015 0 Comments Read More →

Taking (and passing!) the 70-461 Exam and Pursuing My MCSE Certification

Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam.  I decided recently to try and achieve getting my MCSE: Data Platform certification within the next six months.  Taking this exam was step one, and now I have four remaining.  Rather than spending a bunch of money on studying materials, I opted to self […]

Better Together: Reduced Run Time and I/O
By April 29, 2015 0 Comments Read More →

Better Together: Reduced Run Time and I/O

The run-time metric gets all the love, and for good reason.  It’s easily witnessed by end users and the one management cares about.  When DBAs have the task of cutting down the run time of a query, this typically starts in a non production environment, consisting of different server architecture and storage speed than production. If you’re […]

By March 24, 2015 0 Comments Read More →

Use the WordPress Revision Counter to Keep Shipping Posts

I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve wanted to (working hard on this though – at least one post a week!).  There is no getting around it – blogging is time consuming.  Especially technical blogging.  My first few posts were fairly long, […]

Posted in: Syndication, Writing
By March 17, 2015 5 Comments Read More →

Combating the CXPacket Wait Type

Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of the list.  If this is the case for you as well, chances are your server isn’t on fire, but there could be room for improvement. What Does It Mean? Books Online defines the CXPacket wait type as: […]

Posted in: SQL Server, Syndication
By March 10, 2015 0 Comments Read More →

Making Sense of PCIe SSD Use with SQL Server

When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to achieve 100,000 IOPS, the IT world went wild.  While Fusion IO certainly is a pioneer in the PCIe SSD space, this technology has come a long way in its short life, and they aren’t the […]