Viewing 15 posts - 3,466 through 3,480 (of 59,067 total)
If you're using 500GB now, it could be very hard to squeeze down to 128GB.
It's likely, however, that you are not using data compression now. From SQL 2016 on,...
May 18, 2022 at 9:35 pm
This can all be done in T-SQL pretty easily... we just need so reasonable data and task description to work with.
May 18, 2022 at 5:39 pm
FK's to other databases also don't work in "normal" on-prem servers. And, we don't need a separate post on this. 😉 We do need a bit of a better description,...
May 18, 2022 at 5:26 pm
You cannot restore a 2019 database to a 2016 server even if you're in the 2016 compatibility mode on the 2019 server.
May 18, 2022 at 5:11 pm
"Each record"? Which table and could you please provide some test data for the data you want to report on?
All you've provided so far is a table with an IDENTITY...
May 18, 2022 at 4:56 pm
You're still working on your Calendar table. I'll be happy to show you how to do that but that's not the real issue. The issue is, what do you want...
May 18, 2022 at 4:14 pm
Getting back to the original issue, if you'd go back to the original thread that start all this and answer my simple question, you might get somewhere.
As for the question...
May 18, 2022 at 1:51 pm
Ok... That was an important part for us to know there. With that out of the way, we need to know a few things to be able to help you...
May 18, 2022 at 1:39 pm
I work on sql server 2019 i have table have multi column string concatenation as StrSubstance,strmass ,strcasnumber
i need to create filed hashchemical with nvarchar(700) and this will store hash...
May 17, 2022 at 7:29 pm
So please explain how the 1/1/2021 entry for sales of 100 gets knocked down to only 5 calls in the desired output.
To @ratbak's point about providing DDL, please see the...
May 17, 2022 at 7:25 pm
p,s. And, yes... I understand what you're trying to do and maybe even why. I just need for you to answer my question about the ChemicalID nulls/non-nulls above.
May 17, 2022 at 6:18 pm
Does the ChemicalHash table ONLY contain rows where the ChemicalID is NULL or does it have rows where the ChemicalID is not null?
May 17, 2022 at 6:10 pm
This could be pretty easy but, I have to ask, why are you basing your reporting periods on 365*24/12 - 730 hours = 43,800 minutes = 30.4 days? All that...
May 17, 2022 at 5:43 pm
Heh... I was wondering what you used for a base date in your example. 😀
Totally agreed on the rest. My current issue is that the increments are clicking by way...
May 14, 2022 at 9:25 pm
You were attacking a straw man. I never made anything close to the claim you said I did.
Actually, you did...
Actually, the development team should have nothing to...
May 14, 2022 at 8:02 pm
Viewing 15 posts - 3,466 through 3,480 (of 59,067 total)