Viewing 15 posts - 24,136 through 24,150 (of 49,552 total)
Stick an alias on the subquery (just add AS Sub after the close of the bracket for the subquery)
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
August 16, 2011 at 5:41 am
No.
A rollback HAS to complete or your database is structurally and transactionally inconsistent (ie Suspect). There is no way to avoid or abort a rollback.
That 0 seconds, 0% often means...
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
August 16, 2011 at 5:40 am
opc.three (8/15/2011)
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
August 16, 2011 at 3:40 am
Always a pleasure. 😀
There is a workaround - OPTION (MAXDOP n) on that query where n is some number less than the cores you have (drop it until it deadlocks...
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
August 15, 2011 at 4:22 pm
There's only info on one process because there's only one process involved in that deadlock. Look through the deadlock graph, the spid is 63 on every single one.
What this is...
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
August 15, 2011 at 3:38 pm
No.
All you are seeing is the execution. That's it, nothing more.
The sys.dm_exec_sql_text returns the full create statement of the procedure so that you can do things like substring with...
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
August 15, 2011 at 9:18 am
sysobjects and sysindexes are deprecated, should not be used for new development, will be removed in a future version of SQL.
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
August 15, 2011 at 9:03 am
Steve Jones - SSC Editor (8/15/2011)
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
August 15, 2011 at 8:57 am
select object_name(object_id) AS TableName, rows
from sys.partitions
where rows = 0 and index_id in (0,1)
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
August 15, 2011 at 8:54 am
Stefan Krzywicki (8/15/2011)
He doesn't like tech and doesn't even know how to use Excel. He thinks he'll get enough money to live like a king.
And thinks he's hot enough to...
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
August 15, 2011 at 8:52 am
What you're seeing is the procedure executing. Sys.dm_exec_sql_text shows the create statement (and the entire contents) when the proc runs. This is so that you can use the stmt_start 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
August 15, 2011 at 8:50 am
Hmm, I can pick up 4 x 1 TB drives for around $300. RAID 5 config, 3TB internal. Should last for a while.
Or I can get 4 x 1.5...
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
August 15, 2011 at 8:40 am
Those two queries are not equivalent, under many circumstances they'll return different data. Hence it's not a question which is better, it's a question which one returns the data you...
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
August 15, 2011 at 8:02 am
Tom.Thomson (8/15/2011)
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
August 15, 2011 at 8:01 am
There's a good hardware/game shop near where I live, I order almost all my hardware through them. Not quite dealer price but they're cheaper than the major retailers and the...
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
August 15, 2011 at 7:52 am
Viewing 15 posts - 24,136 through 24,150 (of 49,552 total)