118 reputation
18
bio website
location Sweden
age 27
visits member for 2 years, 11 months
seen Aug 4 at 22:20

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
Nov
8
asked DBCC SHRINKDATABASE TRUNCATEONLY 2008R2 vs 2012
Jan
25
comment SQL Server 2008 R2 SQL Server Profiler and “exec sp_reset_connection”
yes one sp_reset_connection executes then 2 or 3 queries are executed and then one more "sp_reset_connection" is executed all with the same SPID
Jan
25
comment SQL Server 2008 R2 SQL Server Profiler and “exec sp_reset_connection”
Reply to update, interesting but still there are 2 or 3 queries between the 2 "sp_reset_connection" why would that result.
Jan
25
comment SQL Server 2008 R2 SQL Server Profiler and “exec sp_reset_connection”
@jl01 well its not bad but it does not explain a 8 sec execution time..
Jan
25
comment SQL Server 2008 R2 SQL Server Profiler and “exec sp_reset_connection”
I checked and there seems to be no direct pattern to this, some times its a select and some times its a update and its diffrent tables..