Browse by Tags

Tagged Content List
  • 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: 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;...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (5 items)