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 57 (568 total posts) < 1 second(s)
  • 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
  • re: Andy-Frickin-Leonard

    Hi Andy This is a great post, thanks for writing it! I want to comment on this idea: &nbsp; &nbsp;I read your comment / post and decided youre right and Ive been wrong all this time, wrote no one. Ever. You might be right about this, but the fact is that people do change their minds, about some things, some times. Sometimes very slowly, ...
    Posted to Andy Leonard (Weblog) by Kalen Delaney on May 7, 2015
  • re: Did You Know: LOB Parameters

    Thanks Adam. But part of my point was that you couldn't do it without a varchar(max) in the mix somewhere! ~Kalen
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 6, 2015
  • Did You Know: LOB Parameters

    &nbsp; So still no juicy bits and bytes post, only this short one to tide me over. Another question from my Budapest class wasnt really a question at all. It was pointing out that something was wrong in my slides! And this makes me think back about a blog post from a while back about features that change that can be easily overlooked. In the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 6, 2015
  • re: Geek City: Accessing Distribution Statistics

    Thanks Steve... who would thunk average key length needed to be more than 32K bytes... but then of course this can keep track of any stats, not just stats on indexed columns. So we could have stats on a varchar(max) or some such. Thanks again! Kalen
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 4, 2015
  • re: Did You Know? What settings to always change

    Hi Adam ... Please feel free.
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 23, 2015
  • Geek City: Point in Time Recovery for Operations on Memory—Optimized Tables

    In my class in Budapest last week, someone asked if point-in-time recovery was supported for transactions on memory-optimized tables.&nbsp; I couldnt think of a reason why not, but I had never tried it. And just because there is not a technical inhibitor to allow certain functionality, it is often the case with a new technology that certain ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 22, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement