Viewing 7 posts - 1 through 7 (of 7 total)
January 18, 2017 at 9:40 am
thomasliddledba - Wednesday, January 18, 2017 12:03 AMComments posted to this topic are about the item Put your Database under Source Control
January 18, 2017 at 4:50 am
Yeah, I can't figure this out. But it is the case that if I simply insert the result of the nested query into a temp table first, then select from...
December 8, 2016 at 12:55 pm
Yeah, I know its a lot. My main question is just what would cause performance to degrade so much just going from:
December 8, 2016 at 9:47 am
Here is a plan where its just the query encapsulated in SELECT * FROM ()
Remember, if I run just the part inside the outer nesting it runs in under 5...
December 8, 2016 at 9:19 am
Actually I did have it joined to a different table at first, but I removed that thinking that the join was the problem.
When I do an estimated execution plan,...
December 8, 2016 at 6:16 am
It's good, but it still doesn't resolve the biggest problem with SQL's PIVOT functionality (which is no fault of yours), which is that there is no way to create a...
December 6, 2012 at 7:13 am