311 reputation
111
bio website
location
age
visits member for 1 year, 7 months
seen yesterday

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


1d
awarded  Yearling
1d
accepted VLF, Shrink and Simple Recovery
1d
comment VLF, Shrink and Simple Recovery
Thanks this is the answer to the question I was originally asking.
1d
comment VLF, Shrink and Simple Recovery
Thanks for the detailed answer. On the point of shrinking does a shrink remove inactive VLFs regardless of where they are in the log?
1d
asked VLF, Shrink and Simple Recovery
Sep
24
awarded  Autobiographer
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