Viewing 15 posts - 31 through 45 (of 88 total)
chris.puncher (3/18/2015)
Out of interest were you able to get an estimated execution plan?
It's been quite awhile since I worked on one of those issues but I usually look at actual...
March 18, 2015 at 11:09 am
chris.puncher (3/18/2015)
That is strange. As Old Hand mentioned re-writing to use sub-queries that filter should produced the same execution plan for simple CTEs.
And I presume that the two would produce...
March 18, 2015 at 11:03 am
I have often found that CTE's allowed me to increase performance though I can only speculate as to why. We have some big, poorly designed tables which can make...
March 18, 2015 at 10:52 am
khushbu (1/13/2015)
I can drop the index and recreate them however I do not want to the...
January 14, 2015 at 10:38 am
Nadrek (11/13/2014)In many cases where the explicit policy says security is valued highly, the actual corporate culture and the actual actions taken do not correspond.
At my first job out of...
November 14, 2014 at 10:14 am
ScottPletcher (10/16/2014)
From a purely performance stand-point, we'd almost certainly want to process Countries prior to it being JOINed
Ultimately in absence of real data we're all just shooting in the dark,...
October 16, 2014 at 2:08 pm
In the execution plan with the case clause, is it determining the 'EUR' vs. other condition before or after the join and where conditions. If it is doing...
October 16, 2014 at 10:33 am
If you only want to output values from table1, then try:
SELECT *
FROM @table1 t1
WHERE EXISTS
(
SELECT 1
FROM @table2 t2
WHERE...
August 15, 2014 at 10:17 am
The author of the article definitely seems to have dropped the ball here. I'm guessing what he intended to write was something like:
CREATE TRIGGER ShowInsert on AuthorsNames
INSTEAD OF INSERT
AS
BEGIN
INSERT...
August 15, 2014 at 9:45 am
Andrew Clarke-161005 (5/30/2014)
May 30, 2014 at 10:17 am
It's possible that you are correct about the intent but the effect of the wording is the same, nonetheless. I can't really subject my company to liability over...
May 29, 2014 at 10:23 am
Jeff Moden (5/5/2014)
May 5, 2014 at 5:35 pm
Andy Warren (5/5/2014)
May 5, 2014 at 1:26 pm
Can one achieve all three? Maybe. Such maxims are rarely absolute -- few things in life are truly absolute. "It depends" is a highly overworked phrase. ...
May 5, 2014 at 10:43 am
LutzM (4/18/2014)
The connection on which the index is created, and all connections trying INSERT, UPDATE, or...
April 18, 2014 at 1:17 pm
Viewing 15 posts - 31 through 45 (of 88 total)