[Video] Office Hours: Sunshine Edition

You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers:

Here’s what you asked in this episode:

00:00 Start 03:18 DBA in VA: I recently discovered the “force order” query hint. I’m usually inclined to let the optimizer do its thing, but I have seen some of our code perform MUCH better with this hint. Are there gotchas/downsides I should know about? 04:29 RoJo: We call SQL from C# code, but it’s hard in SQL to trace where in code the call came from. Is adding a comment at the