never mind , i see that info in the deadlock report links.

Instead can you tell me 1) what the frame ids are?, 2) where in the deadlock report i might...

thx lowell, do one or more lines in there tell you which resources deadlocked, on what indexes etc?

interesting.   i generally rdp into that machine and more often than not when i disconnect, ssms is still left running under my creds.   let me see if that makes a...

i will try to find out.   i dont think any kind of "hog" is running there but i'll show our dba what you suggested.  I think that server is basically...

possible correction, testing now, the target fields didnt exactly match up , maybe the import expects them to match in spite of the column headings.   i'll post back here.

Indeed,  for...

• This reply was modified 3 months ago by stan.

thx brian, its not the only db on that server.  and that 322.8 meg you referenced is just a baseline/poc for a million tsv records.  the forecasted total would actually...

i'll check that Ken, thx.   Never thought of that.   we might download the keepers to tsv then also.   and ingest them straight from tsv's.   our dba didnt catch that potential...

• This reply was modified 3 months ago by stan.

very informative, thx Ken.

thx brian, we would do this on a sunday when users wouldn't be impacted and our level of potential embarrassment would be minimal.

we might be a bit more frugal about...

thx ed b but i'd like to leverage the fact that there are distinguishable data types in this file.   some are int etc.   not sure if doing that would generate...

thx Ken what do you mean by call another phone?  Not the one where the sequence you showed was followed?   Crazy!

thx ratbak.   an sms wouldnt wake me.   sorry if this is a duplicate but i could swear i posted this response already.   but didnt see it when i returned.

well...it wasnt MS, but rather a consulting firm that is notified when you chat on their website where adf is advertised.  Its actually 2 consulting firms and you pick one.

the...

im sitting with ms tomorrow to estimate what our cost would be in just ms charges if we were to migrate our ssis to adf presumably using smaller data objects...

thx jkunkel.   so $200 per month is about what you would expect.  i think you are saying for a low cu which would include the ability to do datasets and...

• This reply was modified 4 months, 1 week ago by stan.
• This reply was modified 4 months, 1 week ago by stan.