I’m a big fan of SQL Server Management Studio; it’s a really great tool with a tremendous amount of functionality. Lately I’ve been working in the new 2008 version of SSMS and a few days ago I noticed some peculiar behavior: when you double click on text that is surrounded by brackets in an MDX query editor, only the text is selected, not the brackets; however, when you double click on text that is surrounded by brackets in a regular SQL query editor, the text and the brackets are selected – even if the text within the brackets contains spaces. How interesting is that?! Below are a couple screenshots to illustrate what I’m talking about:
Selected text in an MDX editor:
Here you can see that I double clicked on the word “Adventure” and only the word “Adventure” is selected.
Selected text in a regular SQL editor:
Here you can see that I double clicked on the word “Test” (you’ll just have to trust me on this!) and the entire text within the brackets, including the brackets, is selected.