Viewing 15 posts - 136 through 150 (of 6,036 total)
These are the tasks we need to do:
For each user, determine their country based on the IP address
Fail on the first step. No point of going any further.
Almost every browser...
_____________
Code for TallyGenerator
April 14, 2021 at 2:50 am
... 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...
_____________
Code for TallyGenerator
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:
_____________
Code for TallyGenerator
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?
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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?
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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 -...
_____________
Code for TallyGenerator
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.
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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?...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
March 30, 2021 at 9:48 am
Viewing 15 posts - 136 through 150 (of 6,036 total)