"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below. [SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...

"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below. [SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...

"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below. [SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...

If my tip was "How to change your desktop wall paper" you would be asking "Why? Is the default not good enough?". Explaining you what benefits there are in using a fewer number of statements and avoiding temporary table sounds as tiresome as explaining...

If my tip was "How to change your desktop wall paper" you would be asking "Why? Is the default not good enough?". Explaining you what benefits there are in using a fewer number of statements and avoiding temporary table sounds as tiresome as explaining...

@ErikEckhardt > Looking at your example, couldn't one just OUTPUT the ParentIDs to a table variable/temp table without needing to use MERGE at all? Then join to this for the children? As you also need to retrieve the "parents' row" this would res...

@ErikEckhardt > Looking at your example, couldn't one just OUTPUT the ParentIDs to a table variable/temp table without needing to use MERGE at all? Then join to this for the children? As you also need to retrieve the "parents' row" this would res...

Jeff, I won't discuss that matter here, as it's not related to the tips. Just know that I also have taken long running queries (taking hours) to reduce their duration to a few milliseconds (using indexes, and something hints)....

Jeff, I won't discuss that matter here, as it's not related to the tips. Just know that I also have taken long running queries (taking hours) to reduce their duration to a few milliseconds (using indexes, and something hints)....

I haven't heard of MERGE being buggy. Do you have any online resources that discuss the matter ? Anyway about the performance improvement consider this scenario: You have two tables, a "parents" table and a "children" table where (as usual) a "paren...