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 57 (563 total posts) < 1 second(s)
  • Webinar 2.3: Large Datatype Storage

    Slides and scripts are now up from today's webinar. https://www.dbbest.com/blog/webinar-2-3-follow-episode-6&nbsp;
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 7, 2017
  • Why Learn About SQL Server Internals?

    It's not just about performance tuning! https://www.dbbest.com/blog/learn-sql-server-internals/ &nbsp; Please&nbsp;also stop by the&nbsp;DB Best booth if you're at&nbsp;the PASS&nbsp;Summit this week! https://www.eventbrite.com/e/live-qa-sql-pass-2017-with-kalen-delaney-tickets-39302959209 &nbsp;
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 30, 2017
  • SQL Server 2016/2017 Internals and Tuning is Online!

    I am presenting my entire SQL Server Internals training online, an hour at a time, though DB Best. Check my blog there regularly for&nbsp;follow-up information including the&nbsp;slides and scripts, a link to the recordings, and solutions to&nbsp;homework exercises. &nbsp;Here is the follow-up to the most recent ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 23, 2017
  • Thank you, SQLSaturday Holland!

    The first event on my Fall tour is behind me now. I had a wonderful time at SQL Saturday Holland. A couple of great questions came up that should lead to blog posts soon! Slides and scripts can now be downloaded from my DB&nbsp; Best blog site: https://www.dbbest.com/blog/thank-sql-saturday-holland/
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 2, 2017
  • I'm Leaving on a Jet Plane

    I'm taking off tomorrow for Holland, UK, Denmark, Germany and Israel: https://www.dbbest.com/blog/im-leaving-jet-plane/#more-11622 You can read the post from DB Best, linked&nbsp;to above, or follow individual links to my public events&nbsp;from here: &nbsp; September 30: SQL Saturday Holland &nbsp; October 5: Getting the most out of the SQL ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 27, 2017
  • Geek City: Changing How To Change Your Database Properties — ALTER DATABASE

    (This article was originally published at https://www.dbbest.com/blog/&nbsp;) 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 ...
    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 cinahcaM madA (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 cinahcaM madA (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 cinahcaM madA (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 cinahcaM madA (Weblog) by Kalen Delaney on June 14, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement