Viewing 15 posts - 301 through 315 (of 10,144 total)
alex.palmer - Tuesday, July 24, 2018 3:35 AMYep! I've done exactly that and I still get a table scan
Can you attach the...
July 24, 2018 at 3:39 am
I hope this is an easy question to answer. 🙂
I'm joining a large table to...
July 24, 2018 at 3:29 am
July 19, 2018 at 8:58 am
Croatia. Their footie was less like international wrestling than Colombia and they had a really sh1t time in living history. France, on the other hand: we're still pissed at the cheese-eating...
July 12, 2018 at 9:13 am
July 9, 2018 at 4:12 am
July 6, 2018 at 9:06 am
You could try making your WHERE clause SARGable:
SELECT
June 19, 2018 at 4:19 am
Please post an "actual" (not "estimated") execution plan as a .sqlplan attachment.
June 19, 2018 at 4:12 am
-- outer references b.[id], d.[id]
SELECT...
June 18, 2018 at 10:03 am
dannydudek - Tuesday, June 12, 2018 9:22 AM
As .sqlplan attachments - the property sheets are important...
June 12, 2018 at 9:25 am
Not sure if anyone has come accross something like this previously.
Got a simple select...
June 12, 2018 at 9:17 am
June 7, 2018 at 7:47 am
May 30, 2018 at 9:18 am
Using Jeff Moden's et al's splitter makes this very easy. Split on spaces, capture words containing '%':
SELECT
May 29, 2018 at 10:07 am
Viewing 15 posts - 301 through 315 (of 10,144 total)