113 reputation
6
bio website
location Sweden
age 26
visits member for 2 years, 2 months
seen Feb 21 at 12:33

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..
Jan
25
comment SQL Server 2008 R2 SQL Server Profiler and “exec sp_reset_connection”
yes Duration = "8192947" 8192947 / 1000000 = 8.1 correct me if my math is wrong.. cpu, reads, writes are all 0
Jan
24
comment SQL Server 2008 R2 sys.dm_exec_sql_text question
Thats true the Compatibility level is set to 80.
Jan
24
asked SQL Server 2008 R2 SQL Server Profiler and “exec sp_reset_connection”
Jan
24
awarded  Scholar
Jan
24
accepted SQL Server 2008 R2 sys.dm_exec_sql_text question
Jan
24
comment SQL Server 2008 R2 sys.dm_exec_sql_text question
Im not sure what this query does but i get no results from it, i can only run it in my master database else i get a "Incorrect syntax" even if i remove the "where s2.dbid = db_id()" i still get no results, but any way thanks you answered my question!
Jan
24
awarded  Supporter
Jan
24
awarded  Student
Jan
24
comment SQL Server 2008 R2 sys.dm_exec_sql_text question
Thanks for the fast reply, but why is the t.TEXT QueryName "create procedure ..." and not "exec ..."? thats gives me the headache..
Jan
24
asked SQL Server 2008 R2 sys.dm_exec_sql_text question
Jan
24
awarded  Autobiographer