Query finishes in SSMS not in PE
DECLARE
@PortfoliofeedCode varchar(50) = 'CADemandWealth'
, @JobID UNIQUEIDENTIFIER = '612E9169-6FAE-4DF2-BC37-1C5F27B58182'
, @ProcessDate DATE = '2016-06-30'
, @UseEventsToDetermineChanges BIT = 0
, @Debug BIT = 1
, @NoExecute BIT = 0
exec [Cert].[UpdateFromStaging] @ProcessDate = '2016-06-30', @PortfolioFeedCode = @PortfoliofeedCode, @UseEventsToDetermineChanges = 0, @JobID = @JobID
By alredy twice as much time has gone by. The row counts are steadily increasing (beyond believable numbers) as I write this.
I just uploaded a csv file as pe.csv.txt. The forum won't let me upload a csv (invalid file type message)
This is consistently reproducible. I can even run the batch to the end minus the last query. When it hits the last query — trouble
I ran sp_whoisactive with things like this. I'm attaching a CSV file with the relevant info. Note that none of the four queries shown is from the query I'm trying to test.
OH, btw while this is going on my NIC is pinned at 100%
PS I don't have an old Free version. This is my first time using PE