Error 8170 says there is insufficient result space to convert a uniqueidentifier value to char. The simple fix is to give the VARCHAR its full 36 characters.
SQL SERVER – Find Queries using Parallelism from Cached Plan
A script by Feodor Georgiev that finds queries using parallelism from the cached plan, along with their plans. Please avoid running it on a busy production server.
SQL SERVER – Identifying Statistics Used by Query
Can you find the statistics used by query? There is no direct tool or DMV for it, but I explain an indirect way through the indexes a query uses.
SQL SERVER – Datetime Function TODATETIMEOFFSET Example
A quick example of the datetime function TODATETIMEOFFSET in SQL Server, and how it differs from SWITCHOFFSET when offsets change.
SQL SERVER – Datetime Function SWITCHOFFSET Example
SWITCHOFFSET changes a datetimeoffset value from its stored time zone offset to a new one. Here is a quick example of how it works in SQL Server 2008.
SQL SERVER – The Self Join – Inner Join and Outer Join
Is a Self Join an inner join or an outer join? It can be either. I build a small new example that shows Self Join as inner join and outer join.
SQL SERVER – Upper Case Shortcut SQL Server Management Studio
Want an upper case shortcut in SSMS? Select a keyword and press CTRL+SHIFT+U to make it upper case, or CTRL+SHIFT+L to make it lower case.