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 54 (540 total posts) < 1 second(s)
  • re: Geek City: Detecting Overflowing Columns

    Hi chenchangliang All that matters is the last 3 bits, since you only have 3 columns. And the last 3 bits are all 0, indicating no nulls. The first 5 bits are irrelevant, and in fact, if you created an identical table, it might have different values for the first 5 bits depending on what was on the page before it was used for this table ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 6, 2014
  • re: Geek City: Detecting Overflowing Columns

    Looks like it... the exact meaning of the bits, that it, which bit means which column, has changed from version to version, and I don't know what version you have.
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 5, 2014
  • Geek City: Lost Identity

    Way long ago, when Sybase first added the IDENTITY property, it took people quite a while to get the hang of using it. Along with being able to automatically generate sequential numbers for each row, we had to tune a configuration option with the geekiest of names: Identity Burning Set Factor.&nbsp; And figuring out how to use this value seemed ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 17, 2014
  • re: Did You Know the History of SQL Server?

    I moved my website at the beginning of this year, and not everything got moved over. I just dug up this file and posted it on the new site. You can find it at:
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 14, 2014
  • re: Geek City: A Hint of Degrees

    This is an awesome discussion, thanks! I don't think Greg is recommending this as best practice in the general case. He is saying that he frequently does this on the systems that he manages (and tunes and tests and monitors). All best practices are just guidelines, and a place to start from for those who are just getting started. But the more you ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 5, 2014
  • re: Geek City: A Hint of Degrees

    Steve... interesting point, although of course, it depends! If I was really creating a distributable script, I should have captured the initial value of 'max degree of parallelism', and reset to that value when I was done. I am just setting back to the default here. AaronM... thanks for the link! I don't recall seeing that post... and of course ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 4, 2014
  • re: Geek City: A Hint of Degrees

    Thanks, Aaron. I know it was documented this way, but as we know, things don't always work exactly the way they are documented. I have a definite recollection that that there was some fuzziness somewhere, which is why I decided to do this simple test on the current versions.
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 3, 2014
  • Geek City: A Hint of Degrees

    This is just a quick post to describe a test I just ran to satisfy my own curiosity. I remember when Microsoft first introduced the query hint OPTION (MAXDOP N). We already had the configuration option max degree of parallelism, so there were lots of questions about how the hint interacted with the configuration option. Some people thought the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on June 3, 2014
  • re: TechEd 2014 Day 1

    Thanks, John! And there'll be a book on In-memory OLTP soon. It's with the publisher now.
    Posted to John Paul Cook (Weblog) by Kalen Delaney on May 12, 2014
  • Geek City: The Hekaton Saga Continues, and some answers to questions

    My Hekaton (aka In-memory OLTP) books is with the publisher. And I have no doubt they will do a much better job than my previous publisher did in bringing my SQL Server 2012 Internals Book into the light of day.&nbsp; My only regret is that my awesome Tech Editor, Benjamin Nevarez, who has been with me since my SQL Server 2008 Internals book, ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 12, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement