Viewing 15 posts - 901 through 915 (of 2,649 total)
use https://www.sentryone.com/plan-explorer - it has a option to anonymize the plan so all object names/columns get replaced with "object1, object2" and so on.
and put it on https://www.brentozar.com/pastetheplan/ and...
April 10, 2022 at 7:28 am
you can't anymore as far as I know.
April 7, 2022 at 10:28 am
problem isn't VS 2022 - issue is that none of the SSRS options will work with .net core - mainly the report viewer which is a must have for many...
April 6, 2022 at 1:10 pm
its always the same issue - dev does not have same volume as QA/Prod and what runs well in dev most times will not run well with volumes.
Just a small...
April 4, 2022 at 12:31 pm
off course it can.
step 1 - set double quotes as text qualifier
step 2 - change the "numeric" column name << THE NAME itself>> to have double quotes around it
step 3...
March 23, 2022 at 10:31 pm
SSIS can do it - you do need to ensure you set the Text Qualifier to Double Quotes
March 22, 2022 at 7:58 am
on those items mentioned, dv360_Line_Item_ID, Date and Event look unique - but you would need to check all your data.
normally you would analyze the data by doing group by in...
March 18, 2022 at 11:24 am
use a construct like the following
select *
from tablename
cross join (select hashbytes('SHA1', concat(field1
...
March 16, 2022 at 11:41 am
I say again - you will never remove that warning from your plan unless the underlying type is the same as your destination column
stop wasting time on things that can't...
March 10, 2022 at 11:51 am
that individual its a waste of time - even the last comment - how to fix that particular conversion to code - was told how - can't do it obviously...
March 9, 2022 at 10:27 pm
you are never going to go past that error - you are converting from a nvarchar(255) to an int - to avoid the issue you will need to change the...
March 9, 2022 at 9:03 am
you likely also should change the BatchSize - 10k is normally way short of the best value - and optimal value also depends if your destination table is a HEAP,...
March 8, 2022 at 11:58 am
the thread above is one you created before with the particular csv file for treasury - I gave you a functional powershell example to download it for their site and...
March 6, 2022 at 9:14 pm
did you try the script I posted on your previous post ?
March 6, 2022 at 7:43 am
this new plan does is not using the same query as the original actual plan you supplied - neither do the tables seem to be the same (record count is...
March 5, 2022 at 5:19 pm
Viewing 15 posts - 901 through 915 (of 2,649 total)