Viewing 15 posts - 26,521 through 26,535 (of 49,552 total)
Stefan Krzywicki (4/25/2011)
I don't know everything, but I also don't have a bunch of letters after my name that claim I should.
I do have a bunch of letters (a long...
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
April 25, 2011 at 7:56 am
Ajay.Kedar (4/25/2011)
I guess the other user can not able to access Table A until second commit get executed.
Depends what is done in the transaction and what locks are taken.
It's 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
April 25, 2011 at 6:41 am
Ninja's_RGR'us (4/25/2011)
David Burrows (4/25/2011)
GilaMonster (4/22/2011)
With no IT experience, it's not likely you'll be able to land a DBA job. Developer, maybe.
Wow Gail! Not sure whether, as a developer, I should...
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
April 25, 2011 at 6:38 am
When you create an index, you indicate whether it's a clustered index or a nonclustered index. Creating a primary key will by default create a clustered index to enforce 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
April 25, 2011 at 6:07 am
I think it has to do with the position of the nested loop join in the plan, and the smaller number of rows in the outer table for the second...
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
April 25, 2011 at 5:45 am
He has an obsession with max worker thread setting at the moment. $Deity knows why, it's one of those settings that shouldn't be touched without a really good reason.
http://www.sqlservercentral.com/Forums/FindPost1097698.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
April 25, 2011 at 5:29 am
iirc CheckDB doesn't check the log file. That is sever though, it will likely need a checkDB with repair allow data loss to rebuild the log.
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
April 25, 2011 at 4:24 am
Ok, the CXPacket is a parallel skew wait. It's just the outer thread waiting for the two parallel branches to finish. Interesting that it's a scheduler yield that the other...
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
April 25, 2011 at 4:22 am
If you can clarify what you're asking, maybe. As it is, I don't understand the question.
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
April 25, 2011 at 4:10 am
Syed Jahanzaib Bin hassan (4/25/2011)
There are several indexes are showing Scanning it must be index seekIndex Seek is better than Index scan,work on it
There's no way to get index seeks...
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
April 25, 2011 at 4:09 am
1204 is the older traceflag. Less information, harder to read.
You should always have exception handling, nothing new here. The app (or the stored proc) should be able to handle 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
April 25, 2011 at 4:02 am
Generic steps: Tune the queries, tune the indexes.
That's about all the general advice there is. If you want something specific, switch traceflag 1222 on. That will result in a deadlock...
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
April 25, 2011 at 3:06 am
Assuming I understand your question, join sys.indexes to sys.index_columns (and then to sys.columns)
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
April 25, 2011 at 3:05 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/Topic1097733-391-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
April 25, 2011 at 3:04 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/Topic1097733-391-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
April 25, 2011 at 3:03 am
Viewing 15 posts - 26,521 through 26,535 (of 49,552 total)