Comments
Sort by recent activity
Did that happen while typing or while formatting. I just tested it and it put the semicolons in the right spot during formatting. / comments
Did that happen while typing or while formatting. I just tested it and it put the semicolons in the right spot during formatting.
Never mind. I just got it to work. It's during formatting. / comments
Never mind. I just got it to work. It's during formatting.
Hi Torsten,
I'm trying to replicate this and I can't seem to get it to work. Is this happening because of formatting or while you're typing? What version of Prompt is it? / comments
Hi Torsten,
I'm trying to replicate this and I can't seem to get it to work. Is this happening because of formatting or while you're typing? What version of Prompt is it?
Best suggestion I can make at the moment is to verify that both versions of SQL Search are the same. It doesn't explain the exact behavior, but it could explain the differences. / comments
Best suggestion I can make at the moment is to verify that both versions of SQL Search are the same. It doesn't explain the exact behavior, but it could explain the differences.
Can you supply any additional information? I'm running the latest version and I can't replicate the bad results you're experiencing. Sorry. / comments
Can you supply any additional information? I'm running the latest version and I can't replicate the bad results you're experiencing. Sorry.
Yes, you can use Express, but we really strongly advise against it due to the size restrictions. However, it will function. / comments
Yes, you can use Express, but we really strongly advise against it due to the size restrictions. However, it will function.
Or 6 actually because it's the VARCHAR side that hurts. I hadn't actually done the calculations like that before. I figured after 2 who cares. 6 ought to be the limit. / comments
Or 6 actually because it's the VARCHAR side that hurts. I hadn't actually done the calculations like that before. I figured after 2 who cares. 6 ought to be the limit.
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...