Comments
Sort by recent activity
I'm not sure I can answer them all, but PB009 makes sense for 1 byte. You actually hurt yourself storing 1byte in a varchar field. That should be CHAR. It's equally slightly silly for a VARCHAR(2), but not as outright wrong.
On PE027, this is likely to occur, but much more likely is to focus on recompile on the statement level, that's why that recommendation.
I like the suggestion on disabling rules forever, because there are a few I'd disable as you do. / comments
I'm not sure I can answer them all, but PB009 makes sense for 1 byte. You actually hurt yourself storing 1byte in a varchar field. That should be CHAR. It's equally slightly silly for a VARCHAR(2),...
I think you have spotted a bug. I just went and highlighted some code and it's showing "Remove Square Brackets" when there are none there. I clicked on remove anyway to see if it toggled and it did not. [image] / comments
I think you have spotted a bug. I just went and highlighted some code and it's showing "Remove Square Brackets" when there are none there. I clicked on remove anyway to see if it toggled and it did...
Yeah, SQL Monitor shows near real time blocked processes, top waits, top queries, deadlocks. All that stuff. It's all right there when you open up the tool. Heck, if there's a blocked process, by default, you get alerted. You don't have to go and track it down. Further, clicking on the alert takes you to the blocked process report. By near, I don't mean hours or minutes. It's less than seconds.
I do love sp_whoisactive too. It just doesn't supply trending, reports, etc. I can't knock it otherwise.
The real issue for me with Spotlight (and I do recognize, I'm talking about a competition product, so please, take anything I say with some suspicion. That's fair.), is two-fold. One, it blocks it's own processes from any kind of reporting. You can't see it, even if it's the only thing running on the server. Two, it's pretty fat. That load you can't see, it's fairly heavy. I honestly can't say the same thing about the other competing products if that helps at all. / comments
Yeah, SQL Monitor shows near real time blocked processes, top waits, top queries, deadlocks. All that stuff. It's all right there when you open up the tool. Heck, if there's a blocked process, by d...
Yay!
Spotlight hides it's own activities from the monitoring results. It's kind of odd. I've never seen a monitoring tool do that before. / comments
Yay!
Spotlight hides it's own activities from the monitoring results. It's kind of odd. I've never seen a monitoring tool do that before.
We show it in near real time. It's only delayed by a few seconds, but, it radically reduces what happens on your server. People can absolutely disagree on whether it's the right approach.
I'd be VERY cautious of Spotlight. Of all the other vendor products out there, it's the single one I've had the most issues with. Do you know that it masks it's own calls to the server? If you really want to evaluate us against another software, pursue another vendor. I think we're better (I do have a prejudice), but the others are much safer than Spotlight. / comments
We show it in near real time. It's only delayed by a few seconds, but, it radically reduces what happens on your server. People can absolutely disagree on whether it's the right approach.
I'd be VE...
So the top 10 is always just a snapshot. We don't continually poll the server in such a way that you can see queries scrolling by on your screen. You can update the snapshot just by clicking the button up on the timeline that will move everything to the latest data. / comments
So the top 10 is always just a snapshot. We don't continually poll the server in such a way that you can see queries scrolling by on your screen. You can update the snapshot just by clicking the bu...
Yeah, that's a very good idea. I'm always hesitant to suggest people to rewrite their code, but this is the way to get it done. / comments
Yeah, that's a very good idea. I'm always hesitant to suggest people to rewrite their code, but this is the way to get it done.
Absolute agreement. It's the right way to get things done. / comments
Absolute agreement. It's the right way to get things done.
To avoid a syntax error you'll probably need to dummy out the linked server. Just give it the same name as the one in production (or wherever) but you can point it to whatever you need to in order for it to work. It doesn't have to be the same server. It just has to have the same name locally. / comments
To avoid a syntax error you'll probably need to dummy out the linked server. Just give it the same name as the one in production (or wherever) but you can point it to whatever you need to in order ...
I used "Align subsequent items with first item", "Align items across clauses" and "Align items to tab stops". It seemed to be what you were looking for based on the initial post. / comments
I used "Align subsequent items with first item", "Align items across clauses" and "Align items to tab stops". It seemed to be what you were looking for based on the initial post.