THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 58 (574 total posts) < 1 second(s)
  • re: Geek City: SQL Server 2016 CTP3 In-Memory OLTP Internals Whitepaper

    Thanks Chris! The 'could' should have been 'count' and it has already been corrected as I update the paper for RTM. Although it is now on page 84, not 73. :-) The whole sentence is: &nbsp;&quot;The bucket count should be at least equal to the number of distinct values for the index key columns.&quot; ~Kalen
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 15, 2016
  • re: Geek City: SQL Server 2016 CTP3 In-Memory OLTP Internals Whitepaper

    Hi Chris What if I just answered 'no'? :-) I don't run the performance tests, Microsoft does, in their labs with many different customers. I am not involved with the testing so I just take the results they give me. Anything I can test for myself, as far as functionality, I will always verify before publishing, but for things that need a lab, or ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 26, 2016
  • Geek City: SQL Server 2016 CTP3 In-Memory OLTP Internals Whitepaper

    &nbsp; Just a quick note that my CTP3 paper has finally been published, and now I can start working on the final version! Heres the link: Enjoy! ~Kalen
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 19, 2016
  • re: Query Optimizer Deep Dive – Part 2

    Hi Paul You mention a test rig to show rules used by each query, and I can't see to find it in your scripts. Have I just not looked in the right file yet? Also, phases.sql references a BigTransactionHistory table. Is there a script to build that that I have overlooked? Thanks and Happy New Year! Kalen
    Posted to Page Free Space (Weblog) by Kalen Delaney on January 2, 2016
  • re: Did You Know: My First New Venture

    I was thinking of some place in the South, and I almost did say Atlanta, but then I realized we'd hadn't been to Disney in way too many years! I do want to get back to Atlanta though, as I have a good friend there I haven't seen in too many years. It's definitely on the list!
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 16, 2015
  • Did You Know: My First New Venture

    As I mentioned in my previous post, I am heading in new directions, and the first goal has now been reached. Rather than working with training companies to offer my SQL Server Internals training, I am now partnering with Denny Cherry and Associates to offer a special opportunity to those wanting to experience a multi-day training event with ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 14, 2015
  • Did You Know: The Times They are A-Changin’

    &nbsp; You know, when Microsoft announces deprecation of a feature, there is no guarantee that the feature will be gone any time soon. All that an official notice of deprecation means is that This feature will be removed in a future version of Microsoft SQL Server. But it could be a far future version. SQL Trace, for example, was announced ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 22, 2015
  • re: Geek City: Q&A

    Thanks for your input D. Michael. A blog post is not like a tweet, which is very ephemeral. There is some content I posted years ago, that I still get comments about and that is still referred to by others. Having my name in this list confirms that this is my blog's home. &nbsp;And of course, I don't always go 3 months between posts. How often do ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 15, 2015
  • Geek City: Q&A

    &nbsp; Ive done it again Ive neglected my blog so long that my name has been removed from the list of SQLBlog contributors on the right-hand side of the main page.&nbsp; So I need to fix that. I have been accumulating a list of questions that have come up during my 5-day SQL Server Internals classes, that I cannot immediately answer. ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 15, 2015
  • Geek City: What rows have been updated under snapshot isolation?

    So here it is, the bits and bytes post Ive been promising. This post is not about Hekaton (in-memory OLTP). This is about the snapshot-based isolation levels that were introduced in SQL 2005, which was called optimistic concurrency at the time. With the advent of Hekatons truly optimistic concurrency in SQL Server 2014, were not calling it ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 22, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement