Viewing 15 posts - 181 through 195 (of 10,143 total)
November 30, 2018 at 6:12 am
November 30, 2018 at 3:32 am
November 30, 2018 at 1:56 am
DECLARE @BULKID varchar(50) = 5006
November 29, 2018 at 9:51 am
November 29, 2018 at 9:37 am
November 29, 2018 at 9:26 am
November 29, 2018 at 3:04 am
That plan has some strange features, e.g. estimated row count for BrandID of over a million for just 9 rows, and parallelism...
Can you try this please, and post...
November 29, 2018 at 3:01 am
@Polkadot, there is an error in your code:
FROM [#Assurant Manufacturer Received] QR
WHERE QR.[Offer_Generate_Date] BETWEEN @FROM_DATE AND @TO_DATE
should be
FROM DistributionCenterFeed.[dbo].[QR_Device_Trade_In_Master_2016onward] QR
WHERE QR.[Offer_Generate_Date] BETWEEN...
November 29, 2018 at 2:47 am
November 28, 2018 at 8:44 am
This could offer a perf lift:
SELECT QR.[Offer_ID]
,QR.[Offer_Generate_Date]
,QR.[Offer_Update_Date]
,QR.[Manufacturer]
,QR.[Model]
,QR.[Serial_Number]
,QR.[Application_User_ID]...
November 28, 2018 at 8:03 am
Add [qty] to index [s_dopicklot].[NonClusteredIndex-20181127-173726]
This could remove the two key lookups from the plan.
November 28, 2018 at 7:25 am
CONVERT_IMPLICIT(nchar(30),
[TotalERP_winwin].[dbo].[s_dodetl].[part_code] as .[part_code]
,0) =
[TotalERP_winwin].[dbo].[s_locqty].[part_code] as [l].[part_code]
November 28, 2018 at 7:03 am
My colleague helped me to try out your restructured script however, the speed is...
November 28, 2018 at 6:53 am
This problem would be far easier to investigate if both plans were available to examine. Is this something you can do?
November 28, 2018 at 3:59 am
Viewing 15 posts - 181 through 195 (of 10,143 total)