194 reputation
9
bio website
location
age
visits member for 1 year, 5 months
seen yesterday

Born in Whitby, cricket follower, player and skipper @NewRoverCC, IT geek, and average company!


1d
accepted Query Plan Different When Using Compiled Values
1d
reviewed Approve suggested edit on Query Plan Different When Using Compiled Values
1d
asked Query Plan Different When Using Compiled Values
Jul
29
accepted Help reading deadlock XML
Jul
29
comment Help reading deadlock XML
Thank to you both for you replies, I will check out what can be done about this.
Jul
28
asked Help reading deadlock XML
Jul
21
accepted Collecting Wait Stats
Jul
21
comment Collecting Wait Stats
OK thanks, I am starting to believe the issue is no longer in SQL server and it may be time to look at the application.
Jul
21
comment Collecting Wait Stats
Good explanation, looking at the average wait times then yes I shouldn't be concerned with that particular wait. If I can't find anything else then looking at the application tier may be my only option.
Jul
21
awarded  Custodian
Jul
21
comment Collecting Wait Stats
Have output the results in my original post, sorry the formatting is terrible.
Jul
21
reviewed Edit suggested edit on Collecting Wait Stats
Jul
21
revised Collecting Wait Stats
Added changes from answer that needs to be deleted
Jul
21
revised Collecting Wait Stats
added 46 characters in body
Jul
21
asked Collecting Wait Stats
Jul
2
awarded  Curious
Jun
19
accepted Turning of Autogrowth for particular file
Jun
19
comment Turning of Autogrowth for particular file
Correct we can't expand the volume, so adding a larger volume and moving the file to it would be my only other option.
Jun
19
asked Turning of Autogrowth for particular file
Jun
17
comment SSIS Foreeach Container Not Failing
The All Execution reports are saying its successful, but I have just tested it again and if I remove the account the file doesn't send.