|
|
|
|
|
|
-
Sergejack Posted 6 Months ago through Just Learned
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 Commented 7 Months ago through Blogs
But what are your conclusions? Are you recommanding the usage of some methods (on specific scenarios)?...
|
-
Sergejack Learned 10 Months ago through Just Learned
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
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
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
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...
|
|
|