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 (580 total posts) < 1 second(s)
  • Geek City: Changing How To Change Your Database Properties — ALTER DATABASE

    (This article was originally published at Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For example, we had sp_addindex and sp_dropindex, as well as sp_addtype, sp_droptype, sp_addlogin and sp_droplogin. For changing certain database properties, we had ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 20, 2017
  • re: The SQL Hall of Shame

    I do not agree that native compilation and native optimization are interchangeable. &nbsp;Just because a Google search shows people using the term incorrectly does not make it ok and meaningful.
    Posted to Adam Machanic (Weblog) by Kalen Delaney on June 22, 2017
  • re: The SQL Hall of Shame

    Adam, do you mean native compilation instead of native optimization? They really don't mean the same thing.
    Posted to Adam Machanic (Weblog) by Kalen Delaney on June 20, 2017
  • re: The SQL Hall of Shame

    @adam... top 3 most useless? There are 215 DMVs in SQL Server 2016SP1. &nbsp;I have used maybe 60 or 65. So that leaves 150 that I have never even used. So how can those be ranked into MOST unused? &nbsp;I know, unused is not exactly the same as useless, but for my personal practical purposes, since you're asking for my personal opinion, they ...
    Posted to Adam Machanic (Weblog) by Kalen Delaney on June 20, 2017
  • re: The SQL Hall of Shame

    @erik... I think there might be a lot of competition if Adam opened it up to useless DMVs as well. But individual DMVs are not technically 'features'. &nbsp;Many DMVs are useless. When the feature of DMVs was introduced, each group within the SQL Server team was mandated to come up with 3-6 DMVs in their area. But they were not mandated to make ...
    Posted to Adam Machanic (Weblog) by Kalen Delaney on June 14, 2017
  • 24 Hours of PASS – Locking and Blocking Q&A

    Thanks to everyone who attended my 24HOP session on Wednesday, September 7. My favorite part is always the Q&amp;A. I wish there was more time to do live Q&amp;A, but because theres not, I get to turn it into a blog post! My session was a snippet of what I will be talking about in my pre-con for the big PASS Summit at the end of next month. ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 13, 2016
  • Geek City: My SQL Server 2016 RTM In-memory OLTP Whitepaper

    &nbsp; Finally, we have a download available. You can go to this page; and scroll down to the section&nbsp; 'Technical Resources'. (NOT the section on the left called White papers). Click on SQL Server 2016 In-memory OLTP technical white paper and you can open or save. OR You can ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 12, 2016
  • Did You Know: Windows Fast Startup is not really a StartUp!

    &#160; So you might already know, but I didnt know, until I learned it, of course. My first Windows 8 machine was my Surface Pro 3 and I LOVED the way it started up so FAST. Fast is good, right? I didnt even bother to wonder WHY or HOW it was so fast. I just thought Moores Law was hard at work. But then I noticed something very strange ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 8, 2016
  • Geek City: The Naming of Things

    &nbsp; As a teacher, and also a student of languages, one issue thats always fascinating to me is how people choose to shorten a compound, or multi-part, name.&nbsp; This is very problematic when the word is from another language.&nbsp; For example, we use the word latte in English as a short form of caffè latte, but we shorten it to just the ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 27, 2016
  • re: Geek City: SQL Server 2016 CTP3 In-Memory OLTP Internals Whitepaper

    Hi Dr. Nick There will not be any more of the big SQL Server Internals books. The last one took over a year to write, and the publisher didn't get it published for over a year after that. And with a new version coming out every couple of years, I can't update the book fast enough to keep up with that. So I will be doing more smaller internals ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 24, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement