Viewing 15 posts - 511 through 525 (of 6,400 total)
While I appreciate this may be a homework set of tables and data, there is a very serious design flaw in the above and that is in the customer credit...
August 31, 2022 at 5:17 pm
What is the reasoning behind moving from FCI to AOAG?
If your only bothered about the HA feature then why go through the pain and just leave them as an FCI.
If...
August 25, 2022 at 5:58 pm
LEFT is also non-sargable so you will get a scan with that second query.
To make it sargable you would need to use LIKE instead. Thanks
"Like" does not work...
August 25, 2022 at 8:34 am
So if I understand the question.
Can an AOAG setup be a subscriber to a transactional replication publication?
Yes it can but you need to do some additional configuration to set it...
August 25, 2022 at 6:48 am
LEFT is also non-sargable so you will get a scan with that second query.
To make it sargable you would need to use LIKE instead. Thanks
August 25, 2022 at 6:41 am
If your running SQL2016 or above look at putting distribution into an AOAG to provide both HA and DR.
August 25, 2022 at 6:04 am
To get the Orders where the OrderDate is in the first 15 days of a month:
WHERE DAY(OrderDate) <=15
That will get them for all months of all...
August 24, 2022 at 10:50 am
It’s not just direct access you need to count for CALS, anything which would indirectly access it would also need a CAL.
So a VOIP phone connected to trunk which connects...
August 23, 2022 at 9:14 pm
You need to speak to your license vendor and or Microsoft.
Never trust what anyone says on a public forum as truth, especially when it comes to something as ultimately complex...
August 23, 2022 at 7:40 pm
From here I suggest you go and speak to someone internal to help you debug the issue you have.
You need the domain knowledge of the application here to help you...
August 20, 2022 at 1:01 pm
What field populates the missing data?
Then you know where you need to look next.
I’m going on a wild guess here it is this calculation field
SUM(vurc.EligiblePurchases * afp.PricePerL) EligibleValue,
So the issue...
August 20, 2022 at 11:40 am
Just to be sure, when you say "VSS", are you good folks talking about "Visual Source Safe"?
Probably Volume Shadow Copy Service? Though I didn't know it left debris.
Yeah in...
August 20, 2022 at 10:22 am
No as it’s essentially an audit and you don’t delete audit data.
The only thing would be to look at what your collecting and the size of the files, number of...
August 20, 2022 at 10:20 am
You need to take the function / procedure you are running to get the bad data. Script that function and run it in a piecemeal fashion to find where the...
August 20, 2022 at 10:18 am
No you can ignore the system object as they won’t affect your user defined objects.
August 19, 2022 at 6:22 pm
Viewing 15 posts - 511 through 525 (of 6,400 total)