Reputation
935
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 14 27
Impact
~102k people reached

  • 0 posts edited
  • 0 helpful flags
  • 32 votes cast
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
Apr
19
comment Clustered vs Nonclustered Index
@ThomasStringer - Thanks Thomas
Apr
19
accepted Clustered vs Nonclustered Index
Apr
19
comment Clustered vs Nonclustered Index
A large majority of the records will meet the Null criteria specified. Would I still want to use teh filtered index for this? I thought filtered indexes were most useful if they narrowed down the amount of records by a significant margine.
Apr
19
comment Clustered vs Nonclustered Index
Yes Sorry SQL Server 2008 R2
Apr
19
asked Clustered vs Nonclustered Index