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 (538 total posts) < 1 second(s)
  • 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
  • re: Geek City: ALTERing a Partition Function

    I am understanding that you have an archive partition and an active partition, and periodically you want to move the active into the archive. You are then combining data from two partitions into one, and there is no way to do that without actually moving data.
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 7, 2014
  • re: Geek City: ALTERing a Partition Function

    Hi Todd (Note: my name is Kalen, not Karen.) Although it's unusual to have a sliding window with just two partitions, it's not unheard of. And yes, you can modify the partition function with a new date so that the first partition now includes all the previous live data, but that will cause data movement, which will cause lots of I/O and logging, ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 7, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement