Viewing 15 posts - 16 through 30 (of 21,963 total)
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
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.
March 1, 2024 at 4:14 pm
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,...
March 1, 2024 at 3:55 pm
So, formatting? Personally, I'd recommend doing that on the front-end. Databases aren't the greatest at formatting.
February 29, 2024 at 2:30 pm
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...
February 29, 2024 at 2:28 pm
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...
February 29, 2024 at 2:25 pm
Whoof! 500 rows took 12 minutes? Honestly, that should be something that occurs in, at most, a few seconds.
Indexes may help (they can also add overhead to deletes as Frederico...
February 29, 2024 at 2:20 pm
I'd start with the source. Here's Microsoft's take on upgrading SSRS. If you get stuck or need details, there are probably other resources that can help.
Testing will be your...
February 28, 2024 at 1:35 pm
But, I have to tell you... even experts may have to try more than once and it frequently means running the code and measuring reads while comparing to execution...
February 27, 2024 at 3:30 pm
In addition to all the stuff already mentioned, I'll add my book on query tuning (link in the signature, yeah, that one does cost money) gets into a lot of...
February 27, 2024 at 2:12 pm
There is no one answer here. Personally, I have been pursuing knowledge of PostgreSQL in addition to SQL Server.
Why that and not something non-relational like MongoDB? Well, after studying a...
February 27, 2024 at 2:03 pm
Viewing 15 posts - 16 through 30 (of 21,963 total)