Columnstore Case Study #2: Columnstore faster than SSAS Cube at DevCon Security

Preamble This is the second in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in my big deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to…

0

Columnstore Case Study #1: MSIT SONAR Aggregations

Preamble This is the first in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in this deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to provide…

0

SQL Server 2014 Columnstore Indexes: The Big Deck

The History Though Columnstore indexes were introduced in SQL Server 2012; they’re still largely unknown.  In 2012, some adoption blockers remained; yet Columnstore was nonetheless a game changer for many apps.  In SQL Server 2014, potential blockers have been largely removed & Columnstore is going to profoundly change the way we interact with our data….

3

Disk Partition Alignment: It Still Matters–DPA for Windows Server 2012, SQL Server 2012, and SQL Server 2014

Introduction I continue to receive dozens of inquiries each year about this issue.  The “fix” in contemporary versions of Windows Server combined with the absence of formal guidance since the white paper’s publication has led some to believe that disk partition is no longer a best practice.  This is incorrect.  Partition alignment remains a best…

0

xPerf: Once I Was Blind and Now I See

I’ve been aware of the buzz around xPerf for quite some time.  I flagged emails from Microsoft Premier Field Engineers Clint Huffman (author of PAL) & Shane Creamer (author of Vital Signs) who in internal DLs both cited the tool way back in 2008. Robert Smith is also a Microsoft PFE.  He is one of…

4

SQL CAT New Whitepaper: Data Compression: Strategy, Capacity Planning and Best Practices by Sanjay Mishra, et al.

Data Compression: Strategy, Capacity Planning and Best Practices Hot off the presses, the SQL CAT team has just published a new whitepaper for which I had the opportunity to provide a technical review.  The author is SQL CAT best practices maven Sanjay Mishra.  Contributors include SQL CAT member Sunil Agarwal and architects Marcel van der…

1

Disk Partition Alignment (Sector Alignment): Make the Case: Save Hundreds of Thousands of Dollars

I recently collaborated with Microsoft PFE Daniel Janik to create a template to make the case for disk partition alignment.  Perhaps your customers or stakeholders within your organization can benefit.  This work was recently broadcast throughout PFE DLs as well as the April 2009 SQLRAP Newsletter.  Thanks also to Cindy Gross & Ward Pond for…

11

Wait Stats by Joe Sack

Wait stats rock.  As I shared recently with friends, when it comes to SQL Server performance, wait stats are the #1 arrow in my quiver, the first tool out of my toolbox, the Vera of guns (see the Firefly episode Our Mrs. Reynolds to divine that reference). In a previous post I stated the importance…

2

Wait Stats Introductory References

Preamble For those of you who are already facile with SQL Server wait stats, there’s nothing new here.  However, if you’re a n00b, this is a great place to start. History As I commented here on SQL MVP Jason Massie’s blog, I first became aware of the importance of wait stats in an editorial for…

3

MSDN Blog Box Beefed Up and SProcs Tweaked For New! Improved! User Experience

A few weeks ago Cindy Gross brought this tweet to my attention from SQL Server MVP Jason Massie: statisticsio:  I should pdf the essential posts from @aspiringgeek and sqlcat because everytime I really need them blogs.msdn.com is crawling. https://twitter.com/statisticsio/statuses/1377928792 Yes, aspiringgeek is my Twitter handle.  Who’d’ve thunk it?  And who’d’ve thunk Microsoft’s blogging backend could…

4