Comments
Sort by recent activity
OK, sorry. I think I figured it out. I finally changed the short cut for SQL Query Editor and Comment selection now works with my Ctrl-Shift+C. Thank you for the time. / comments
OK, sorry. I think I figured it out. I finally changed the short cut for SQL Query Editor and Comment selection now works with my Ctrl-Shift+C. Thank you for the time.
Yes, thanks for the clarification. I changed my global short cut to be Ctrl-Shift-C. Even if I change it back to the default Ctrl-K, Ctrl-C it still does not work. The Red Gate SQL Suite is the only Add On I have installed. I'm using SSMS 2014.
Thanks for the help. / comments
Yes, thanks for the clarification. I changed my global short cut to be Ctrl-Shift-C. Even if I change it back to the default Ctrl-K, Ctrl-C it still does not work. The Red Gate SQL Suite is the onl...
Do you mean the Enable Suggestions option? / comments
Do you mean the Enable Suggestions option?
Thank you. That is good news. It will be great to have this fixed.
Regards,
Aaron / comments
Thank you. That is good news. It will be great to have this fixed.
Regards,
Aaron
The version that I have is 5.2.0.40.
What do you need me to provide to help you solve this. I could give you the script that is generated, would that help? Did you want the script along with the schema? / comments
The version that I have is 5.2.0.40.
What do you need me to provide to help you solve this. I could give you the script that is generated, would that help? Did you want the script along with the sc...
Thanks for the additional information. This is good to know, although what I would like to be able to do is compare the local table.column to the remote table.coloumn.
Your discovery would be helpful in other situations though.
Regards,
Aaron / comments
Thanks for the additional information. This is good to know, although what I would like to be able to do is compare the local table.column to the remote table.coloumn.
Your discovery would be helpf...
OK, I'm back again and wondering if anyone from red gate has my post here about having an additional comparison key to further limit the rows that are checked for changes. I think a timestamp column would be perfect for this, a datetime column could also be used though. I would say that if there is a timestamp column on the table then it should be used to perform the additional comparison.
So when the additional comparison key is found it's tested for a difference and only then does the full row get compared to find out what changed. This must be faster then how it's done now which I suspect is to simply check all column/values in the table for all comparison keys even when there is no difference. / comments
OK, I'm back again and wondering if anyone from red gate has my post here about having an additional comparison key to further limit the rows that are checked for changes. I think a timestamp colum...
I'm still very curious as to why someone has not explained to my why my idea for speeding up the comparison process won't work. My original question continues to be ignored. Anyone? I would really like to know why this won't work. / comments
I'm still very curious as to why someone has not explained to my why my idea for speeding up the comparison process won't work. My original question continues to be ignored. Anyone? I would really ...
I'm actually talking about having an additional custom comparison key.
So when the comparison key does match then the custom comparison key is used. This way even when the comparison key does match only the matches with a differing custom key will be checked.
The comparison key you are talking about is only used for find matches, or what will become update statements, and not to find changed rows. / comments
I'm actually talking about having an additional custom comparison key.
So when the comparison key does match then the custom comparison key is used. This way even when the comparison key does match...
I am still having this problem. What should I do?
Aaron / comments
I am still having this problem. What should I do?
Aaron