THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 55 (542 total posts) < 1 second(s)
  • Did You Know? I’ll be talking for a full day at the PASS Summit!

    &nbsp; Ill be speaking on my new favorite topic Hekaton! (aka In-memory OLTP) http://www.sqlpass.org/summit/2014/Sessions/Details.aspx?sid=6152 I was delighted to have the chance to give a taste of the presentation for the the 24 Hours of PASS preview on September 9th.&nbsp; I was in Germany at my daughter's house that day, so although my US ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 18, 2014
  • re: Geek City: DBCC's Hidden Snapshot

    The blog post Paul mentions is still available, but I don't know whether Paul has recorded this.
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 7, 2014
  • 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: http://sqlserverinternals.com/?attachment_id=254
    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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement