Comments
Sort by recent activity
PeterTilsted said:
For day one, i am waiting for Grant to open my eyes on Extended Events, rest of the speakers are pure Bonus :-) Stay safe everybody
I hope it was useful. Happy to answer any followups. I had more material and just ran out of time. I need to have about three hours for that session. / comments
PeterTilsted said:
For day one, i am waiting for Grant to open my eyes on Extended Events, rest of the speakers are pure Bonus :-)Stay safe everybody
I hope it was useful. Happy to answer an...
I'm looking at version 9 of SQL Prompt and that format choice is absolutely available. Just de-select "Place ON keyword on new line" and "Place ON condition on new line" and you'll get exactly what you want. / comments
I'm looking at version 9 of SQL Prompt and that format choice is absolutely available. Just de-select "Place ON keyword on new line" and "Place ON condition on new line" and you'll get exactly what...
Sorry. Not good. What version of SSMS and what version of SQL Prompt are you experiencing this with? / comments
Sorry. Not good. What version of SSMS and what version of SQL Prompt are you experiencing this with?
Thanks for the feedback Jerry. That's not a very big database and you shouldn't be seeing poor performance on it. I'll bring this up with the devs. / comments
Thanks for the feedback Jerry. That's not a very big database and you shouldn't be seeing poor performance on it. I'll bring this up with the devs.
Hi, Could I ask for a little more information please? How many tables & indexes are we talking about for this warehouse? How many partitions on those indexes? I'm not sure this has any bearing, but I'm trying to get a sense of the scale of the problem. / comments
Hi,Could I ask for a little more information please? How many tables & indexes are we talking about for this warehouse? How many partitions on those indexes? I'm not sure this has any bearing, but ...
That may be a valid approach for now. Maybe we need a way to keep the selections optionally. Some people would be equally displeased with the behavior if it kept everything by default. Having both might be an approach. Please look over User Voice and if you can't find this, add it. I'll be happy to vote on it: https://redgate.uservoice.com/forums/147879-sql-data-compare There is already a request on the WHERE clause: https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/32152780-use-the-same-where-clauses And, I think this might be similar to what you're asking for: https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/30973708-maintain-custom-table-selections-after-first-datac If not, please, add yours. We do use these to drive development. / comments
That may be a valid approach for now. Maybe we need a way to keep the selections optionally. Some people would be equally displeased with the behavior if it kept everything by default. Having both ...
Each set of databases (or backups, scripts. whatever you're comparing) is a unique set. Changing the targets is telling Compare that you have a new thing for it to look at. We can't know that these two sources are the same after you switch one of them, so it has to reread and reset, just in case they are different. / comments
Each set of databases (or backups, scripts. whatever you're comparing) is a unique set. Changing the targets is telling Compare that you have a new thing for it to look at. We can't know that these...
You can use RESTORE VERIFYONLY to test the backup. That's how I'd do it. Documentation is available here. / comments
You can use RESTORE VERIFYONLY to test the backup. That's how I'd do it. Documentation is available here.
Unfortunately, I'm not able to replicate the error. I've used your code and I'm formatting multiple times. I've even added additional code to try to force it to rewrite things, but it's not dropping the period like you're seeing.
What version of SSMS are you running? Are there any other settings, language, etc., that might be different between your system and mine that could help me replicate the problem? / comments
Unfortunately, I'm not able to replicate the error. I've used your code and I'm formatting multiple times. I've even added additional code to try to force it to rewrite things, but it's not droppin...
Can you post what version you're running please? I've tried to replicate this behavior and I'm not seeing it. / comments
Can you post what version you're running please? I've tried to replicate this behavior and I'm not seeing it.