108 reputation
7
bio website
location San Diego, CA
age
visits member for 3 years
seen Aug 7 at 23:08

Aug
7
comment Why are there Victimless Entries on the Deadlock Graph?
@BillSoranno I added the query to the question. Fortunately I can still pull up the link on my end.
Aug
7
revised Why are there Victimless Entries on the Deadlock Graph?
added query to find a query by its sqlhandle
Apr
3
awarded  Popular Question
Oct
16
comment Encrypt/Decrypt output & input for SSIS task
I don't have a specific requirement for encryption level, but naturally want to make it as secure as possible.
Oct
16
revised Encrypt/Decrypt output & input for SSIS task
Clarified question
Oct
16
comment Encrypt/Decrypt output & input for SSIS task
I need to encrypt the text files the SSIS package creates from my database. Then at a later point I'll have to decrypt the text files and import them using another SSIS package.
Oct
16
comment Encrypt/Decrypt output & input for SSIS task
ENCRYPTBYKEY() and DECRYPTBYKEY() seem to operate on columns individually. This would result in alot of work to encrypt all the columns one by one, which I suppose I could do if necessary. But I'm really looking for a way to encrypt the entire output file, not just a column.
Oct
16
asked Encrypt/Decrypt output & input for SSIS task
Sep
4
accepted SSMS Object Explorer Details causes deadlock while job is running
Sep
4
answered SSMS Object Explorer Details causes deadlock while job is running
Aug
24
asked SSMS Object Explorer Details causes deadlock while job is running
Aug
10
awarded  Benefactor
Aug
10
awarded  Scholar
Aug
10
comment Why are there Victimless Entries on the Deadlock Graph?
The deadlocks are gone! Thanks for your help.
Aug
10
accepted Why are there Victimless Entries on the Deadlock Graph?
Aug
8
comment Why are there Victimless Entries on the Deadlock Graph?
I was able to use this query to identify one of the queries by it's sqlhandle.
Aug
8
comment Why are there Victimless Entries on the Deadlock Graph?
This could be it. I'm going to sprinkle some MAXDOP on there and see if it resolves the deadlocks.
Aug
8
awarded  Promoter
Aug
1
awarded  Supporter
Jul
31
revised Why are there Victimless Entries on the Deadlock Graph?
added 2 characters in body