|
|
-
Sergejack forgotten 12 Months ago through Just Learned | 1 Point
"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...
|
-
Sergejack Liked 12 Months ago through Just Learned | 1 Point
"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...
|
-
Sergejack forgotten 12 Months ago through Just Learned | 1 Point
"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...
|
-
Sergejack Commented 12 Months ago through Just Learned | 1 Point
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...
|
-
Sergejack Commented 12 Months ago through Just Learned | 1 Point
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...
|
-
Sergejack Commented 12 Months ago through Just Learned | 1 Point
@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...
|
-
Sergejack Commented 12 Months ago through Just Learned | 1 Point
@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...
|
-
Sergejack Commented 12 Months ago through Just Learned | 1 Point
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)....
|
-
Sergejack Commented 12 Months ago through Just Learned | 1 Point
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)....
|
-
Sergejack Commented 12 Months ago through Just Learned | 1 Point
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...
|