Viewing 15 posts - 571 through 585 (of 5,111 total)
The OP did in their opening post.
That's twice in two days you've highlighted my inability to comprehend basic English, you scoundrel! 🙂
Don't worry, I'm pretty sure you see my...
February 7, 2020 at 2:38 pm
Personally, I would use Powershell to do this, which can be put directly into an Agent Task; thus no need for SSIS
No one mentioned SSIS apart from...
February 7, 2020 at 2:32 pm
Personally, I would use Powershell to do this, which can be put directly into an Agent Task; thus no need for SSIS:
$SourceDirectory = "C:\temp"
$DestinationDirectory = "C:\YourDirectory\SubDirectory"
$File =...
February 7, 2020 at 2:22 pm
Attached is a screen grab of the whole flow and a screen shot of the task that creates the table
That doesn't show us a lot; we need to see...
February 7, 2020 at 11:51 am
why has the table been created with '_A2488A8ACD43465D9A357D33A3478440 ' appended to the table name
It wouldn't be; not natively anyway. To me, this suggests you have some DDL triggers, that's changing...
February 7, 2020 at 10:28 am
OK, yes, it was the order of the processing being different when EXEC was used and the SQL inside the SQL was being run. When the SQL was run, any...
February 7, 2020 at 9:21 am
upgrade quickly, then you can use querystore and plan guides
Upgrade (to 2019) is on the cards, but probably not till Q3 this year. Me working out the budget has...
February 6, 2020 at 5:08 pm
Ok, that looks like I might be onto something. The SP has loads of scans, however, the SQL being run is all seeks. I jsut got the Actual Execution Plan...
February 6, 2020 at 4:45 pm
I haven't reviewed them yet, but did wonder if, perhaps, the order in which the data engine is running the joins is different when I run the SQL and when...
February 6, 2020 at 4:40 pm
Can we assume that you have a QA/Test environment which is intended to be a close-to exact copy of Prod? If so, does the problem happen there too?
If not,...
February 6, 2020 at 4:17 pm
Maybe you should have written: "If you were to run EXEC dbo.NoRepro in my environment ..." 🙂
dbo.NoRepor won't even do it in my environment though >_< It's literally only...
February 6, 2020 at 2:39 pm
is ti sql 2019? we've seen a few issues with functions not behaving as expected - not honouring order by... is it possible that this is another sql 2019...
February 6, 2020 at 2:11 pm
If you were to run EXEC dbo.NoRepro;, then you would get the errors above. If, however, you ran the SQL inside the SP, then it would succeed.
No errors for me:
February 6, 2020 at 2:09 pm
Hi Mike,
That isn't how DATEFROMPARTS works. It's DATEFROMPARTS(<year>,<month>,<day>) regardless of the language. The block you quote is me describing when they error usually occurs; but that could never happen with...
February 6, 2020 at 1:09 pm
Thom
Are you sure you don't have any five-figure years? That would explain the DATEFROMPARTS and CONVERT failures, although not why TRY_CONVERT returned no NULLs.
The constraint stops values that large...
February 6, 2020 at 11:43 am
Viewing 15 posts - 571 through 585 (of 5,111 total)