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

Mar
6
comment incorrect value from SUM Function
@ypercube - Thanks. I'll read up and correct my ignorance.
Mar
6
comment incorrect value from SUM Function
@ypercube I don't understand. Why would a float data type all of a sudden cause sql to incorrectly add the values?
Feb
4
comment linked server hanging
Sorry I should have guessed that. It's something I hadn't thought to try but I can't take that db offline during regular hours. Thanks though.
Feb
4
comment linked server hanging
Unfortunately the linked server doesn't seam to like that command. I get an error: User does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks.
Feb
4
comment linked server hanging
+1 as that's an excellent reply unfortunately though not the answer. I have no msaccess processes open. I do a copy of the db down to my location which ensures the SQL Server is the only connection.
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.
Oct
1
comment select row data as column list
@AaronBertrand yeah sorry I'll get that up in a min
Jul
30
comment Need to understand parallel query execution error
Thank you. You've been a huge help.
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
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
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
Apr
19
comment Clustered vs Nonclustered Index
@ThomasStringer - Thanks Thomas
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
Mar
20
comment Appropriate Action for Dead Locks / Blocking
@AaronBertrand - Yeah felt unwise to me too. Thats why I asked. I'm trying to figure a solution that allows me to react quickly before the website starts timeing out on customers. This was the solution suggested by my boss. I put the brakes on till I could get some more research done.
Mar
12
comment Query to determine a count by rolling interval
That'll do it. Thanks Sebastian.