configured to shut down on failure
license core limitaion
managed lock priority
ON_FAILURE = SHUTDOWN
online index rebuild
sql 2012 edition upgrade
SQL Server 2012
sql server 2012 books online
Browse by Tags
Tagged Content List
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...
28 Apr 2014
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,...
28 Apr 2014
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...
23 Apr 2014
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...
25 Nov 2013
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...
5 Sep 2013
Page 1 of 1 (5 items)
© 2014 Microsoft Corporation.
Privacy & Cookies