SQL Server Management Studio ( SSMS ) – Editor – Tabs and Spaces

Background When writing code, one gets to decide whether Tabs are kept as is; or have the editor automatically converts tabs to spaces.   SQL Server Management Studio ( SSMS ) Let us review SSMS Toolings as it relates to tabs and spaces.   Outline Editor Editing Choose Tabs or Spaces Selected Text Convert "Tabs … Continue reading SQL Server Management Studio ( SSMS ) – Editor – Tabs and Spaces

Error processing execution plan results. The error message is: There is an error in XML document

Background Tried to access a Query's execution plan and ran into a wall. The error is pasted below. Error Message Image Text   Resolution Looked more into it. And, determined that I was using SQL Server Management Studio v2005. In this case I should be using a newer version, v2014 to be exact.

Microsoft – Management Studio – Data Grid – Entering Special Characters

Background As much as I love working with Management Studio there are still areas that perplex me.   Data Entry Here I am trying to correct some rows that has "bad data" in them, but Data-grid is spitting back at me. For example, the data reads "Café Lower Level Eest" & "Café Lower Level Wast" … Continue reading Microsoft – Management Studio – Data Grid – Entering Special Characters