Viewing 15 posts - 28,861 through 28,875 (of 49,552 total)
Offhand, no idea. The DMVs should. sys.dm_exec_sessions cross apply sys.dm_exec_sql_text.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 6:51 am
Yes. The connection has been killed and SQL is rolling it back. Be patient.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 6:10 am
only4mithunc (12/15/2010)
But he has declared @WHERE and assume the first parameter value is not null , the the statement is
SET @WHERE = @WHERE +...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 6:10 am
winston Smith (12/15/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 5:46 am
Developer 2005 (12/15/2010)
According to my experience,first one is more fast then other.
It's not a question of speed. They are two distinct, different queries, they are asking different things and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 5:43 am
Developer 2005 (12/15/2010)
(may be deadlock condition)
If it was a deadlock SQL would have detected and handled it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 5:33 am
premkuttan.lakshmanan (12/15/2010)
wat should i do to get rid of that?
Wait. It was doing some large data modification and has to roll back all of the changes. Rollback usually takes...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 5:32 am
Chris Morris-439714 (12/15/2010)
I *think* Gail has blogged on this, will look.
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 5:26 am
I don't think that dropping databases is logged in the error log. It should be in the default trace.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 5:26 am
only4mithunc (12/15/2010)
Also you have to initialize @Where NVARCHAR(4000) to ' ' otherwise theentire string will be NULL.
No he doesn't.
He's initialising the string right after declaration. Initialising it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 5:23 am
Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 2:05 am
WayneS (12/14/2010)
Gail, are you trying for sainthood?
No. You have to be dead to become a saint. Doesn't sound appealing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 1:57 am
Why SSIS? Backups are typically taken with a maint plan or SQL script. You can take them via SSIS, there's a backup database task in the control flow toolbox, just...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2010 at 1:56 am
evald (12/14/2010)
Yes, even bugs are well documented.Microsoft is saying: "Look man, for some obscure implementation reason of my engine i cannot guarantee you that the order by will work".
Absolutely not....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2010 at 10:46 pm
The problem is not in adhoc sql string. It's in the EXEC. You don't use = to set data types. Red is wrong.
EXEC sp_executesql @sql,N'@_StartDate = datetime, @_EndDate =...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2010 at 2:47 pm
Viewing 15 posts - 28,861 through 28,875 (of 49,552 total)