Viewing 15 posts - 241 through 255 (of 22,197 total)
I've poked the team to see what's up and linked back to here.
I don't have a hotel booked either if that helps at all (and I know it...
March 26, 2024 at 4:46 pm
So I'm hoping maybe someone (coughStevecough) might be able to provide some info for me...
I'm going to be attending the Redgate Summit in Chicago, I want to get my...
March 26, 2024 at 3:35 pm
We are spoiled for choices. I don't think there's a wrong one as such.
There are ones that are better fits to you as an individual. For example, I went down...
March 25, 2024 at 1:28 pm
I am fortunate to have worked my entire career in organizations where admitting to and owning your mistakes is respected, and failing to do so gets you fired. My...
March 15, 2024 at 5:46 pm
Sounds really good! I have never used SQL Prompt for this purpose but used it for other, mostly code formatting and best practices suggestions purposes.
QUESTION: is SQL PROMPT similar...
March 14, 2024 at 1:02 pm
Thanks, Grant!
Good to hear from you. I have learned quite a few good things from your books and other presentations over the years.
Thanks! Happy to help where I can.
March 14, 2024 at 1:01 pm
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,...
March 11, 2024 at 3:32 pm
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,...
March 11, 2024 at 3:32 pm
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...
March 11, 2024 at 3:03 pm
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...
March 11, 2024 at 1:58 pm
Same old story.
Thanks for sharing.
March 5, 2024 at 5:12 pm
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...
March 5, 2024 at 2:35 pm
I'm not paying 1500 bucks a year (plus however many hours a year it takes to get it approved and renewed) for infrequent code refactoring lol
That's not...
March 5, 2024 at 12:41 pm
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...
March 1, 2024 at 7:38 pm
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...
March 1, 2024 at 5:21 pm
Viewing 15 posts - 241 through 255 (of 22,197 total)