Reputation
880
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 14 24
Impact
~83k people reached

  • 0 posts edited
  • 0 helpful flags
  • 32 votes cast
Jan
29
comment unclear SQL Server Issue
Maxdop is set to 6. The network admin said that he didn't see anything in the windows logs. I'll have to find the cluster logs. I'm not certain if those were checked.
Jan
29
revised Get maximum number with combination of columns
realized it needed an order by for clarity
Jan
29
answered Get maximum number with combination of columns
Jan
29
asked unclear SQL Server Issue
Jan
13
awarded  Popular Question
Jan
10
awarded  Notable Question
Nov
5
awarded  Popular Question
Oct
2
awarded  Notable Question
Oct
1
accepted select row data as column list
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