Microsoft has recently released a single installer which now installs SSMS and ADS both together in a single Installation.
Arrow in Execution Plan – SQL in Sixty Seconds #136
Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.
SQL SERVER – Adding Values Containing NULLs
Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.
SQL SERVER – 7 Questions about OUTPUT Clause Answered
I got many questions from the users and I have listed them in today’s blog post. Let us discuss 5 Questions about the OUTPUT Clause Answered.
SQL SERVER – Create Table From Another Table
One of the DBAs from the recently asked me if I know any easier way to create a table from another table without generating a CREATE TABLE script.
SQL SERVER – Datatype Storing Unicode Character Strings
I explained how Unicode datatype works, you can read that blog here SQL SERVER – Storing a Non-English String in Table – Unicode character strings.
SQL SERVER – Storing a Non-English String in Table – Unicode Strings
Yesterday I had a meeting with my client Performance Health Check, and they wanted to know how to store a non-English string in a table.