Viewing 15 posts - 25,471 through 25,485 (of 49,552 total)
http://sqlinthewild.co.za/index.php/2011/05/17/on-transactions-errors-and-rollbacks/
The Xact_abort rolls back everything and aborts the *batch*, however each piece broken with GO is a separate batch, so execution simply resumes at the beginning of the next batch
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
June 16, 2011 at 8:07 am
All of mine got rejected 'max allowed sessions'. Am a little bleak about that, though I understand the reason. I thought in previous years it was max 2 conference sessions...
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
June 16, 2011 at 7:51 am
If you're going to drop it, then drop it. Disabling an index removes the b-tree and leaves the metadata. Dropping it removes the b-tree and removes the metadata.
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
June 16, 2011 at 4:33 am
If you mean a table that behaves like a # table (scoped to your connection, random name to avoid collisions, dropped when your connection closes) then no.
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
June 16, 2011 at 4:32 am
1000 milliseonds = 1 second.
As for the total....
If you and I both stand in a queue for 2 minutes, then our cumulative wait time is 4 minutes (2 minutes...
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
June 16, 2011 at 3:45 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1126335-148-1.aspx
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
June 16, 2011 at 3:43 am
opc.three (6/15/2011)
That's ridiculous :hehe:How does one get the engine to store -0.00 ?
Well there's a reason it's considered a data-purity form of corruption....
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
June 16, 2011 at 3:26 am
sqldba_icon (6/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
June 16, 2011 at 3:21 am
No. Not the pictures of the deadlock graph. There's a hell of a lot of info that's lost in a picture.
The deadlock graphs are files. XML files. I want 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
June 15, 2011 at 1:00 pm
hammad772001 (6/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
June 15, 2011 at 12:59 pm
Please zip and post the deadlock graph files themselves.
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
June 15, 2011 at 12:40 pm
Possibly that at the time you made the nomination the person didn't make the grade. MVPs can nominate, can say that someone should be considered, but that's 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
June 15, 2011 at 12:27 pm
Roy Ernest (6/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
June 15, 2011 at 12:10 pm
Craig Farrell (6/15/2011)
lfernandesfotos (6/14/2011)
The analysis is interesting, however, can make life difficult for developers that use the database.
Developers should be going through procs anyway. I can hand you a...
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
June 15, 2011 at 11:37 am
Ninja's_RGR'us (6/15/2011)
How does that MVP feedback work? Is it like the exceptionnal DBA where you have to raise your hand to get on the list on candidates?
For me I...
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
June 15, 2011 at 11:35 am
Viewing 15 posts - 25,471 through 25,485 (of 49,552 total)