Viewing 15 posts - 48,616 through 48,630 (of 49,552 total)
Inserts by themselves should not be able to deadlock. that requires 2 or more commands in a transaction ussually. Is there a trigger on that table?
You can try setting 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
June 7, 2007 at 2:28 am
I'm not sure why you're doing a group by without aggregates. Duplicate records?
Try something like this (2005 specific)
SELECT
mile_code, DeltaT, rep 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
We stand on the bridge and no one may pass
June 7, 2007 at 2:00 am
Are you thingking of the SQL_Text DMV?
SELECT
er.session_id, start_time, database_id, st.text
FROM 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
We stand on the bridge and no one may pass
June 7, 2007 at 1:41 am
I think it has something to do with the schema. When I took the schema definition out of your XML, the select returned one row.
I haven't had that much expereience...
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 7, 2007 at 1:21 am
I was supposed to be writing 442 at the end of this month, but it's been postponed to next month due to time constraints.
I wrote 441 a couple months back...
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 7, 2007 at 12:56 am
I was supposed to be writing 442 at the end of this month, but it's been postponed to next month due to time constraints.
I wrote 441 a couple months back...
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 7, 2007 at 12:53 am
Try catching the Stored Proc: SPStarted event instead of the RPC started event. I know that in 2005 the SPStarted event doesn't filter.
AFAIK the filtered words are 'password' and 'setapprole'
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 6, 2007 at 12:48 am
I studied for 431 from just Books Online and the Pocket administrator's guide. I took the requirement list from MS site and went through each them one by one.
That said,...
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 5, 2007 at 2:40 am
Interesting. I recall that SQL 2000 would never create multi-column stats. I looked in the 2005 BoL and couldn't find anything that outright stated that it will or won't. 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 5, 2007 at 12:11 am
Interesting. I wasn't aware of that.
I would still suggest that you try and find the cause of the deadlock and eliminate it, rather than handling and trying again.
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 4, 2007 at 4:21 am
Profiler is a very good place to start. If you run it during the slow downs you should be able to identify the source of the long duration locks
Also make sure...
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 1, 2007 at 4:27 am
Using brain dumps is considered cheating and if MS becomes aware of it, they will revoke all your certs and put a lifetime ban on your account.
If you want 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
June 1, 2007 at 2:24 am
I'd suggest you run profiler and catche the deadlock graph event. That will give you a graphical view of what was caused the deadlock, both the one that was picked as...
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 1, 2007 at 1:12 am
At their simplest, statistics tell the optimiser the distribution of data in a column (or a set of columns). It can help the optimiser know how many rows to expect...
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 1, 2007 at 12:08 am
I am just curious how much time and effort I should put into some of this or if I should just "put my faith in Microsoft" and that DTA knows...
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
May 31, 2007 at 12:43 am
Viewing 15 posts - 48,616 through 48,630 (of 49,552 total)