AngryHacker

less info
stack exchange network profile network profile
388 reputation
10
bio website
location
age
visits member for 11 months
seen Jan 7 at 23:30
stats profile views 11

49 Actions

suggestions reviews revisions comments badges posts accepts all
Apr
8
 awarded  Popular Question
Dec
20
 awarded  Nice Question
Dec
17
 accepted Does firing off an indefinite WAITFOR increase the log file size?
Dec
17
 accepted Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?
Dec
17
 comment Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?
Thanks. Why does the status show as SUSPENDED?
Dec
17
 comment Does firing off an indefinite WAITFOR increase the log file size?
I don't understand your last comment. The transaction is active because I issued a WAITFOR (RECEIVE... Could you expand? Perhaps, I misunderstood.
Dec
17
 awarded  Commentator
Dec
17
 comment Does firing off an indefinite WAITFOR increase the log file size?
Would WAITFOR (...) TIMEOUT 3600000 solve the problem? E.g. release hourly.
Dec
17
 asked Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?
Dec
17
 asked Does firing off an indefinite WAITFOR increase the log file size?
Nov
1
 asked What is a good auto-generated key for a federated database?
Sep
16
 accepted Performance impact of waiting on a service broker message
Sep
16
 comment Performance impact of waiting on a service broker message
So given that I will only have a single app with the WAITFOR... request, it shouldn't be an issue at all.
Sep
14
 asked Performance impact of waiting on a service broker message
Jul
16
 comment Quick look at how much RAM is allocated to SQL Server?
EXEC sp_configure 'max server memory'; also does not exist in SQL 2008.
Jul
16
 awarded  Editor
Jul
16
 revised Quick look at how much RAM is allocated to SQL Server?
update column name
Jul
16
 suggested suggested edit on Quick look at how much RAM is allocated to SQL Server?
Jul
16
 accepted Quick look at how much RAM is allocated to SQL Server?
Jul
16
 asked Quick look at how much RAM is allocated to SQL Server?
1 2 3