This may be surprising to many, but I have seen quite a few times so far so decided to blog over here. Here is the sequence of the action: The developer turns on Graphical Execution plan for any query with CTRL+M Now turns on the execution plan in the text…

This blog post is a follow up post of an excellent write up by my friend Vinod Kumar. I suggest you read his blog post here SSMS Tips–Object Explorer Details. After reading his blog post, I called him up and had an interesting conversation with him. Here is our conversation:…

Yesterday I posted article where we discussed how to rename a table name where identifier is part of the tablename. Read the blog post Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name. If the table name contains an identifier, it is…

Earlier I wrote a blog post SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL and in follow up to the blog post, I received few questions. Let me try to answer those questions in following blog post. Q: How do we know if setting which returns NULL when concated to another NULL value is…