Comments
Sort by recent activity
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...
Just piling on here a little. The key is that you can't demo or promote products in non-paid sessions at Summit. That said, if you're showing, for example, a spike in CPU, you could use the Analysis screen of SQL Monitor to show that spike. However, if you walked someone through finding a spike in cpu using SQL Monitor, you'd be crossing the line, big time. It's a tough line to walk and you don't want to get kicked out of Summit for crossing it. However, you could use our tools for graphics & such without violating the rules. Just don't promote or demo and you're fine. / comments
Just piling on here a little. The key is that you can't demo or promote products in non-paid sessions at Summit. That said, if you're showing, for example, a spike in CPU, you could use the Analysi...
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.
Nuts. I can't replicate it. I'm still getting semi-colons. What version of SSMS or VS? / comments
Nuts. I can't replicate it. I'm still getting semi-colons. What version of SSMS or VS?
Well I'm at a loss. I'm on the same version of SSMS and it's working every time I try it.
Are there additional scripting elements before the example? I know that if there are scripts that contain errors it sometimes won't put semi-colons in. I also hit issues sometimes on giant scripts (I'm working on a couple of books and the scripts are enormous, sometimes formatting is pretty unhappy with me). Are these part of a multi-thousand line script? / comments
Well I'm at a loss. I'm on the same version of SSMS and it's working every time I try it.
Are there additional scripting elements before the example? I know that if there are scripts that contain e...
Interesting. I'm a little behind you on updates, 9.0.4, but it's working there. I'll get updated and see what happens. / comments
Interesting. I'm a little behind you on updates, 9.0.4, but it's working there. I'll get updated and see what happens.