199 reputation
10
bio website
location
age
visits member for 1 year, 7 months
seen Sep 18 at 8:19

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


Sep
16
asked SSIS FTP Delete Remote Files
Aug
19
comment SSRS minus first two dates as the header
Yes I think I will look at doing it that way instead.
Aug
18
comment SSRS minus first two dates as the header
It means in some cases I got high positive numbers and in others negative numbers, which don't add up if doing a subtraction. It does support the DATEADD() and DATEDIFF() functions, however I don't know how to reference only the first two items of data in the column.
Aug
18
asked SSRS minus first two dates as the header
Aug
17
awarded  Popular Question
Aug
5
comment Index Tuning Question
OK here we go: dl.dropboxusercontent.com/u/11680929/Plans/WithIndex.sqlplan and dl.dropboxusercontent.com/u/11680929/Plans/WithoutIndex.sqlplan
Aug
4
asked Index Tuning Question
Aug
4
asked Multiple Trace Files or Replay
Jul
31
accepted Query Plan Different When Using Compiled Values
Jul
31
reviewed Approve suggested edit on Query Plan Different When Using Compiled Values
Jul
31
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