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: Windows 2012 and .Net 3.5 Feature Install

    Windows 2012 Sever RTM was this week, I can think of no better way of honoring it than to write a post on the first thing you will have to work around when installing anything that needs .Net 3.5. While it is well know the .Net is a feature that must be installed separately, what is not obvious is that...
Page 1 of 1 (5 items)