Your comments
Using Microsoft SQLServer (Express Edition) shall not be a replacement for SQLite. It is meant as a second database backend to support workgroups. The features supported, such as a fulltext-search-engine, should make it possible to use it in general. Client installation requirements are kept to a minimum, because it will be necessary to install the SQLNative-Client library only.
Quote: But what to do when several tags are selected?
No need to support this. Iterating the tag list will clear any existing tag filter and only allows to change the selection one by one. Just as Ctrl+U does for 'Untagged'. Iterating the list is a method of its own.
Quote: Whether the bullets should be removed is a good question.
The answer is No. Sometimes i need to remove formatting like underline, italic, etc. I definitely want to keep my bullet list! As posted a month ago, i can select all relevant lines and press Ctrl+L twice to remove the bullets, if i really like to.
Take my example with the tags @office, @home. To check all notes for tag @office you must select that tag either by mouse-click or by selecting it using the searchbox. Next you have to reset the tag-filter and proceed with the same steps for @home. And so on....
My suggestion is an abbreviation for that process.
I understand your (complete) answer. Probably you also wanted to finish the post, because these things just can take up so much time. Anyway, I think it is not easy to divide censorship from constructive advancement. If the changes can be discussed here and thereafter result in a modification of the original post, anyone can reconstruct the story. People can learn from the story, just as they can do now by following our discussion. Well, i am not angry. I got your point. Let's go on.
Users posts should not be changed, unless the user has asked for or agreed to do so. Changing posts without consultation is not acceptable.
As for Ctrl+Up/Down i did run a test with the notes list and the search box. Since i did not have a selection, i didn't notice, that the key is already in use. Now i have checked with the help. Of course you are correct here. Still i think Ctrl+Up/Down for tag scrolling would be more useful. I expect to use this many times, whereas i have never used the key the way it works right now.
It would be sufficient to have a dialog in the main "Help" menu, e.g. "Usage Statistic".
Customer support service by UserEcho
In order to support conflict management introduce a record-revision to the notes table. This is an integer, that gets incremented on each consecutive sql-update. Before updating a note, check that the original record-revision is still the same to the current value in the database. If it's not, a conflicted is detected. In this case offer a dialog with three options: a.) Discard my changes b.) Save my changes as a new note c.) Cancel. Of course a dialog to solve/edit the conflicts could be another solution, but i consider the effort for such an implementation as disproportionate.
In case of a delete-conflict, discard the request to delete the note.