|
|
-
Sergejack Posted 6 Months ago through Just Learned | 5 Points
Whenever you have a filtered index you just might find that it's not used when its columns are compared to a variable.
The thing is, SQL Server will always make an Excecution Plan that would work with any values for those variable (including the values ...
|
-
Sergejack Liked 10 Months ago through Just Learned | 1 Point
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
T...
|
-
Sergejack Liked 10 Months ago through Just Learned | 1 Point
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
T...
|
-
Sergejack Learned 10 Months ago through Just Learned | 1 Point
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
T...
|
-
Sergejack Learned 10 Months ago through Just Learned | 1 Point
Do you know ANSI-92 versions of T-SQL therefore early 6.5 version was so programmatically influenced. This was tha old-style LEFT OUTER JOIN syntax.
SELECT TableX.ID, TableY.ID
FROM TableX, TableY
WHERE TableX.ID *= TableY.ID
T...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
SELECT COUNT(*) FROM tblSARGTest WHERE ProductID = ProductID;
is actually equivallent to
SELECT COUNT(*) FROM tblSARGTest WHERE ProductID IS NOT NULL...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
SELECT COUNT(*) FROM tblSARGTest WHERE ProductID = ProductID;
is actually equivallent to
SELECT COUNT(*) FROM tblSARGTest WHERE ProductID IS NOT NULL...
|
-
Sergejack Liked 11 Months ago through Just Learned | 1 Point
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context...
|
-
Sergejack Liked 11 Months ago through Just Learned | 1 Point
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context...
|
-
Sergejack interesting 11 Months ago through Just Learned | 1 Point
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context...
|