Thanks! Happy to help where I can.

Without seeing the queries or the plans, I'm just guessing.

Possible differences between using a table and a temp table that could result in performance issues are, of course, the indexes,...

Without seeing the queries or the plans, I'm just guessing.

Possible differences between using a table and a temp table that could result in performance issues are, of course, the indexes,...

It's not so much that you "feed" it, as Prompt is already looking at your data structures, so, yeah, that's what it does. It takes your data structures and uses...

Great points. I wasn't even thinking about that at all. Happily, I haven't received so much as a finger wag for dropping the ball. I mean, Steve is going to...

Same old story.

Thanks for sharing.

I haven't begun to use all of SQL Prompt's features. But it's code completion is much better than SSMS built-in intellisense. I have found Smart Rename & Find Invalid...

That's not...

OK, I'm a little confused as to what it is that you're looking to get here.

You're describing lock waits, which system_health captures. Locks that exceed 30 seconds get reported. It's...

Oh, right. That's the Extended Events GUI, not system_health. Sorry. I misunderstood.

System_health is just a monitoring tool. It shouldn't be messing with your systems in any way. You can set...

I don't see it there either. Be sure you're on either an Enterprise or a Development instance. I'm on Development, but I can't find it. Documentation is sparse too.

I'm not sure I understand what system_health GUI you're referring to? Can you clarify a bit? There is a system_health Extended Events session. You can stop that, and modify it,...

So, formatting? Personally, I'd recommend doing that on the front-end. Databases aren't the greatest at formatting.

It just makes mistakes. Lots of them. Also, the hard part is getting your tables & such into the language model.

Now, Redgate, my employer, is adding a way to do...

I'd suggest taking a look at Flyway. It's open source, but there's also a paid version with a lot more functionality.

Flyway uses a migrations based approach to deployments. That...