Viewing 15 posts - 46,546 through 46,560 (of 49,552 total)
Hans Lindgren (5/14/2008)
But I would argue that no application with these number of hits would not have connection pooling turned off and serializing all DB access..
I have a rule when...
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 14, 2008 at 8:09 am
Jonathan Mallia (5/14/2008)
You might consider switching the database to simple recovery model if possible.....
And lose the ability to do point-in-time recoveries.
Why do you suggest that?
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 14, 2008 at 7:41 am
This is the 3rd year I've submitted. No luck so far. Will see.
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 14, 2008 at 6:43 am
Not that I know of. Inserts happen in a batch. If one row fails the entire batch will fail.
Your best bet is validating the data before you try inserting 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
May 14, 2008 at 6:42 am
Cross post.
Already answered -
http://www.sqlservercentral.com/Forums/Topic500325-8-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
May 14, 2008 at 6:40 am
Switch the order of this index, or create a new one
mgr_acc - Non clulstred index on mgr_28B_code,bintent,b_id - 11160 rows
Change to Bintent, b_id, mgr_28B_code
or
b_id,...
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 14, 2008 at 6:38 am
Please don't cross post. It just wastes people's time.
Already answered-
http://www.sqlservercentral.com/Forums/Topic500298-65-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
May 14, 2008 at 6:30 am
As a hopeful speaker, I second the above. Prizes are nice, but the party's plain good fun.
Do you know why PASS changed the way things were done re the codes?
Steve,...
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 14, 2008 at 6:26 am
Make sure you rebuild all your indexes after the shrink. Shrinking a database badly fragmetns indexes.
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 14, 2008 at 6:21 am
Maybe.
Check that your indexes are not fragmented and that your statistics are up to date.
Check that implicit transactions is not a connection default.
You can check the execution plan of 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
May 14, 2008 at 2:54 am
Christopher Stobbs (5/14/2008)
Thanks for the reply.That what I would expect to happen.
The current table count is 5.
So if I make it 0 it should be 5+1 which is 6.
No, if...
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 14, 2008 at 2:50 am
Readers take shared locks. Changing the data requires an exclusive lock, which is incompatible with a shared lock. Hence the blocked process waits.
It shouldn't have to wait long though. 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
May 14, 2008 at 2:33 am
Books Online
Current identity value is set to the new_reseed_value. If no rows have been inserted to the table since it was created, the first...
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 14, 2008 at 2:27 am
Depends
What was the blocked process doing?
What was the blocking process doing?
Generally you fix blocking problems by optimising code and ensuring that indexes are adequate.
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 14, 2008 at 2:14 am
Please don't cross post. It wastes people's time and fragments replies.
No replies to this thread please.
Direct replies to the following:
http://www.sqlservercentral.com/Forums/Topic500040-150-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
May 14, 2008 at 12:28 am
Viewing 15 posts - 46,546 through 46,560 (of 49,552 total)