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
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...
1 Aug 2012
Page 1 of 1 (5 items)
© 2014 Microsoft Corporation.
Privacy & Cookies