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

  • 0 posts edited
  • 0 helpful flags
  • 9 votes cast
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?
Jun
24
awarded  Popular Question
May
6
comment How does paging work with ROW_NUMBER in SQL Server?
Don't down vote without writing why?
Apr
4
awarded  Popular Question
Nov
8
awarded  Editor
Nov
8
revised DBCC SHRINKDATABASE TRUNCATEONLY 2008R2 vs 2012
added 30 characters in body