810 reputation
618
bio website
location New York, NY
age 37
visits member for 3 years, 1 month
seen Apr 14 at 13:10

Oct
1
revised select row data as column list
added 318 characters in body
Oct
1
comment select row data as column list
@AaronBertrand yeah sorry I'll get that up in a min
Oct
1
asked select row data as column list
Jul
30
comment Need to understand parallel query execution error
Thank you. You've been a huge help.
Jul
30
accepted Need to understand parallel query execution error
Jul
29
comment Need to understand parallel query execution error
is there anything that would be indicative of a run awway query? Anything I can use to attempt to identify queries that are at risk of this?
Jul
29
comment Need to understand parallel query execution error
@Kin I thought that 0 ment that SQL Server managed how many threads it should be using. Why would this result in starveing SQL Server for thread resources?
Jul
29
comment Need to understand parallel query execution error
max worker threads Min = 128, max = 32767, config = 0, run = 0
Jul
29
comment Need to understand parallel query execution error
@Kin I have 12 processors (0 - 11) processors then two logical processor to NUMA Node map: entries Node 0, Node 1
Jul
29
comment Need to understand parallel query execution error
Max Degree of Parallelism is set to 0
Jul
29
asked Need to understand parallel query execution error
Jul
29
accepted Checking SQL Server's memory utilization
Jul
29
asked Checking SQL Server's memory utilization
Jun
18
awarded  Popular Question
May
23
comment View column has an 8000 character limit?
@AaronBertrand - I've edited to give more information and bring the post up to date as requested.
May
23
revised View column has an 8000 character limit?
added 1143 characters in body
May
22
asked View column has an 8000 character limit?
May
6
accepted Log file growth issues
May
6
comment Log file growth issues
its a stored procedure that pulls data from a linked server access database and inserts it into a sql server database
May
6
asked Log file growth issues