Browse by Tags

Tagged Content List
  • Blog Post: SQL 2014 In-Memory OLTP papers released

    We have released a new feature in SQL Server 2014 that may significantly improve OLTP application performance called “In-Memory OLTP” codename "Hekaton". A single blog post cannot come close to describing the features, benefits and complexities of implementing and using Hekaton. Take a look...
  • Blog Post: SQL 2014 Standard Edition Improvements

    Good News Everyone! SQL Server 2014 Standard Edition has new features for 2014. 1. Increase in supported RAM to 128GB . 2. Addition of Buffer Pool Extension (BPE). Imagine BPE as a warm cache for the SQL Server buffer pool. As clean pages are aged out of the buffer pool due to memory pressure,...
  • Blog Post: New Paper Released on SQL 2014 Cardinality Estimation

    There is a new Cardinality Estimator in SQL 2014 . I wanted to drop a quick post to cover a few key points; All of this can be found in Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator A re-designed cardinality estimator in SQL 2014 has been implemented to improve the...
  • Blog Post: Head Blocking Script, Again…

    Did I mention I use this blog to keep scripts so I do not lose them? Well, I do, it is easier to find stuff on the internet than it is on my own machine. This script is not new, it is not extra special for 2014, it's just a basic head blocker script with query statement text. Finding who is backed up...
  • Blog Post: SQLCAT.com has left the building, but not really...

    Wow, it has been entirely too long since I have posted anything. But I can assure it has been for good reason. I have been neck deep in Hekaton, Column Store and a few other treats in SQL 14. However, I am going to talk about none of that today. If you have not noticed the SQLCAT.com site was taken down...
Page 1 of 1 (5 items)