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
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
SQL 2014 Preview announced at TechED
In case you missed it this week and I doubt you did, it was announced at TechED that SQL 2014 will be available for preview the end of this month (June). The biggest most interesting feature for me is In Memory OLTP, of which I am happy to share the first white paper has been published by Kalen Delaney;...
4 Jun 2013
SQL 2012 Security Audit 3 (Predicate and Failure)
This is the script to bring it all together. In this case I have opted for just a server side specification with a filter on the database and exclusion of system objects. You can certainly leave the access to system objects, however it will generate a significant number of audit entries. I encourage...
19 Jul 2012
Thank you, and Who is on my schedulers?
In the last two days I have had over 2000 page views on the two posts I have put up. I know I am not that good of blogger yet and the posts are not riveting, so I can only assume that it is the work of Joe Sack and Grant Fritchey who have blasted my blog out to the twitter–verse. All I can say...
22 Jun 2012
Page 1 of 1 (5 items)
© 2015 Microsoft Corporation.
Privacy & Cookies