Viewing 15 posts - 136 through 150 (of 6,036 total)
... you can probably just remove the CTE.
+1
You definitely would do better without CTE.
And I'd also changed the order of appearance of the objects in the query - to...
April 14, 2021 at 2:22 am
Output of the splitter function is not used anywhere in SELECT, further JOIN or ORDER BY.
Therefore it's better be not in INNER JOIN but in WHEE EXISTS check:
April 14, 2021 at 1:58 am
You mentioned it's a VM.
Did you check what's going on on other VM's sharing the same physical Server?
What's going on on the physical server itself?
April 11, 2021 at 1:58 am
For choice of clustered index columns, I am confident that they are correct. They are int or bigint columns and are very frequently used in many queries.
on an average...
April 9, 2021 at 8:56 am
Yes, the point is excellent, and to me it seems there is no question.
If you have a look at the topic starter:
tables have 1 month worth of data
there will no...
April 9, 2021 at 4:27 am
Some of my queries return upto 15 million records which gets pushed to a temp table.
Does not look like a good choice of querying strategy.
It's never a good idea...
April 8, 2021 at 1:25 pm
I mean , we don't face high CPU, Memory or IO latency.
What kind of issues do you face then?
What's the bottleneck which makes your procedures slow?
April 8, 2021 at 11:52 am
Remember to exercise some caution when entering new worlds.
Don't be like that romantic couple from Washington who went travelling around the world to bring love and understanding to troubled parts...
April 8, 2021 at 1:26 am
Clustered index contains all the data pages on its leaf level. Therefore scanning a clustered index on any table will be more expensive operation than scanning any of non-clustered indexes...
April 8, 2021 at 12:55 am
I created [_sandbox] database for this purpose, deployed the script and scheduled it to run every minute.
It's been 15 or 20 executions since then - no issues.
I'm telling you -...
April 6, 2021 at 5:21 am
Check what's going on with msdb. Where are the files located, size of it, any spikes, available space, locking, etc.
April 1, 2021 at 7:10 am
Just remembered a thing about insufficiently specified requirements.
A wife sends her husband to a grocery shop:
- Buy a loaf of bread and if there will be eggs buy a dozen.
20...
March 31, 2021 at 2:43 am
Shifting gears a bit, I was just a bit disappointed because you obviously have a function. How difficult would it have been to simply post it as a function?...
March 31, 2021 at 1:21 am
Remote scan usually means copying the remote table to local memory (tempdb) in its entirety and then scan it locally.
If the same object is scanned repeatedly it might make sense...
March 30, 2021 at 9:48 am
Well, dbo.HHHMMSS2DATETIME is a function.
But the overall solution is a script, true. But I don’t see it as a problem, it’s a feature! 😀
I don’t know how the duration is...
March 30, 2021 at 6:18 am
Viewing 15 posts - 136 through 150 (of 6,036 total)