316 reputation
111
bio website
location
age
visits member for 1 year, 8 months
seen yesterday

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


1d
asked Replication Snapshot folder not cleaning up
1d
answered Machine account causing a Token-based server access validation failed with an infrastructure error
1d
asked Machine account causing a Token-based server access validation failed with an infrastructure error
Oct
7
comment TempDB Log Space and ACTIVE_TRANSACTION
I stupidly ran the CHECKPOINT so now have NOTHING as the log_reuse_wait_desc. In terms of the space its 1GB chunks and 26GB left. I tried to use sys.fn_trace_getinfo to find any auto growths but didn't find any which is also confusing.
Oct
7
asked TempDB Log Space and ACTIVE_TRANSACTION
Sep
30
awarded  Yearling
Sep
30
accepted VLF, Shrink and Simple Recovery
Sep
30
comment VLF, Shrink and Simple Recovery
Thanks this is the answer to the question I was originally asking.
Sep
30
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?
Sep
30
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