Archive for October, 2013

By October 22, 2013 4 Comments Read More →

Why I’m Excited About Hekaton

I recently read Microsoft’s research paper on Hekaton, the new in-memory database engine in SQL Server 2014.  When I first heard about it, I was pretty excited, but after reading the deep dive specs, I’m ecstatic.  I highly recommend checking out the research paper in its entirety, but for those who prefer a faster read, […]

Posted in: Hekaton, SQL Server
SQL Server Partitioning: Getting Started
By October 12, 2013 1 Comments Read More →

SQL Server Partitioning: Getting Started

Partitioning is a feature that has been around since SQL Server 2005.  It allows for users to split a table across multiple filegroups.  Multiple filegroups means the opportunity to store a table across multiple volumes.  If you have a SAN that has disk tiers, you can use partitioning to store the data you want, where […]

Posted in: Partitioning, SQL Server