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
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.