[Video] Office Hours: Ask Me Anything About SQL Server On My Patio

Videos
1 Comment

I sit on the porch and discuss your highly voted questions from https://pollgab.com/room/brento.

Today’s discussion includes:

  • 00:00 Introductions
  • 00:27 DK: What was your Gordian Knot problem?
  • 03:25 George: How exactly does locking work on INSERT INTO…SELECT FROM?
  • 05:48 Michael: Can I tell if hyperthreading is turned on or off?
  • 07:25 Party People: What are the most common anti-patterns you see?
  • 10:20 Recap

 

Previous Post
[Video] Office Hours: Ask Me Anything at the Westman Islands Harbor
Next Post
[Video] Office Hours: Ask Me Anything About SQL Server in Stokkseyri

1 Comment. Leave new

  • I disagree about hyperthreading. I have personally solved many problems with queries that run much too long, just by shutting off hyperthreading. The way to see it is using sysinternals coreinfo -c.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.