Reputation
Next privilege 200 Rep.
See reduced ads
Badges
1 1 9
Impact
~17k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Jan
29
accepted Migrating log files should i copy file/directory permissions?
Jan
29
comment Migrating log files should i copy file/directory permissions?
Does ROBOCOPY /MIR <Source> <Target> copy both the file and the permissions or just copy the permissions to an existing file?
Jan
29
asked Migrating log files should i copy file/directory permissions?
Nov
27
comment Maintaining SQL Server 2008 R2 on Windows 10
@BuahahaXD development machine?
Nov
22
awarded  Famous Question
May
21
awarded  Popular Question
Feb
25
accepted remove old SSRS Schedule jobs
Feb
25
answered remove old SSRS Schedule jobs
Feb
19
asked remove old SSRS Schedule jobs
Feb
4
comment When To Update Statistics?
I would recommend using some thing like ola.hallengren.com/… this solution only rebuilds/reorganize and updates what is needed this way you might shortenthe time your maintinance plan takes and also save a hole lot of log space..
Aug
4
awarded  Notable Question
Jul
17
revised Analyse what caused a pagesplit afterwards?
added 152 characters in body
Jul
17
comment Analyse what caused a pagesplit afterwards?
Just as you specified fn_dblog loses information when the log is truncated so with fn_dblog i can't go backwards.. anyway thanks for your answer.
Jul
17
awarded  Commentator
Jul
17
comment Analyse what caused a pagesplit afterwards?
Is there any way to go backwards in time with this solution or it has to be done as the page splits are happening? thanks for pointing out the performance problem, in my case i did not execute the commands on our production server instead i executed them on my own SQL server and then restarted it when i was done.
Jul
17
revised Analyse what caused a pagesplit afterwards?
deleted 1059 characters in body
Jul
17
answered Analyse what caused a pagesplit afterwards?
Jul
17
revised Analyse what caused a pagesplit afterwards?
added 1116 characters in body
Jul
17
revised Analyse what caused a pagesplit afterwards?
added 1116 characters in body
Jul
17
asked Analyse what caused a pagesplit afterwards?