Viewing 15 posts - 6,436 through 6,450 (of 59,070 total)
Thanks for taking the time to post the readily consumable data.
I agree... Sergiy's shortened version doesn't work the same as the code you posted. I've not worked with Boolean Algebra...
September 9, 2020 at 2:49 am
I haven't encountered issues yet.
In any case, best is to start your preparation using SQL Server Data Migration Assistant
As a bit of a sidebar, I won't use...
September 8, 2020 at 1:43 pm
What size is the actual index? I'm not talking about the memory grants, etc. How many pages does the actual index have?
As for as the memory grant formulas being used...
September 8, 2020 at 1:40 pm
The requirement is export the rows to a text file in a path when it meets the condition. Like say when there is a transaction of particular store, the...
September 8, 2020 at 1:04 pm
To be honest, I think this whole task might be a mistake in the making. It sounds like someone is trying to build a homegrown version of replication. What is...
September 7, 2020 at 10:14 pm
Thanks Jeff that's a good point, which I do not know the answer. I don't have control over the code. I doubt the support Guy I'm talking to, would...
September 7, 2020 at 10:08 pm
To be honest, I'd spend a little more time on the forecast formulas. They appear to take a flat line set of actuals and "predict" a 50% increase that results...
September 7, 2020 at 7:56 pm
I'm not a PowerShell user but a Google for "check if file already exists using powershell" turns up things that may easily help do what you want. Try it.
Even better...
September 7, 2020 at 7:43 pm
Yes for my testing, I have database called tesdb and testing it by manual insert. So if this is not the right way of doing, can you please advise...
September 7, 2020 at 7:33 pm
Do you actually have a table called "TestDB"? If so, which database is it in and what in your BCP command identifies that database?
I also agree with Sergiy. Having this...
September 6, 2020 at 1:06 am
It's not what is expected, and the data condition won't occur. Each column is null-able, but both cannot be null.
You should post some readily consumable test data and the...
September 6, 2020 at 12:47 am
If the only values available in the result column are Y or N - you could do this:
Select r.id
From Response r
...
September 5, 2020 at 11:10 pm
Actually, a single scan would be just fine:
SELECT ID
FROM Response r
GROUP BY ID
HAVING MAX(result) <> MIN(result);
You've just gotta love the old ways. 😀
September 5, 2020 at 4:14 pm
Ok... I have a question, especially seems to be coming up a lot lately.
To what end does someone need this type of information? What will the information ultimately be used...
September 4, 2020 at 4:41 pm
The words might be strong, but apparently not strong enough, considering how the masses of developers mindlessly follow the pattern (by default from MS) and clustering everything by ID
True...
September 4, 2020 at 4:29 pm
Viewing 15 posts - 6,436 through 6,450 (of 59,070 total)