Viewing 15 posts - 13,741 through 13,755 (of 49,552 total)
abitguru (3/25/2013)
Thanks McSQL, when I try those hits, I can't access other ID when I select ID 1 for example.
Probably because SQL is taking row locks on every single row...
March 25, 2013 at 10:43 am
There's no way to get historical deadlocks in SQL 2005 unless you already had some traceflag or trace on at the time.
To catch future deadlocks, turn traceflag 1222 on, the...
March 25, 2013 at 10:36 am
vikingDBA (3/25/2013)
I use > 30% and > 50 pages to rebuild. Less on either just gets...
March 25, 2013 at 10:29 am
kevaburg (3/25/2013)
Information related to non-clustered indexes are stored as a view in the MASTER database named sys.partitions.
The view definition is in the system resource database. The data that the...
March 25, 2013 at 9:12 am
abitguru (3/25/2013)
[/b]begin transaction
SELECT * FROM Reque_pa with (updlock) WHERE CEREQ = 1
WAITFOR DELAY '00:00:10';
commit transaction
This is seriously exactly what you have in your application, a select with a waitfor?...
March 25, 2013 at 9:08 am
Cool, please post the table definition, the index definition and the code that contains that transaction (at least the begin tran part through to the selection of the parameter).
March 25, 2013 at 7:55 am
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
You'll need dynamic SQL on this one.
March 25, 2013 at 7:49 am
You won't be able to drop or restore the database, just restart SQL. Shouldn't take any recovery time at all.
March 25, 2013 at 7:45 am
Restart the SQL instance.
March 25, 2013 at 7:31 am
abitguru (3/25/2013)
1 - I understand that I can't lock (for selecting, updating) a row with a select statement. Am I right?
No, you've done exactly that several times in this thread,...
March 25, 2013 at 7:29 am
terry999 (3/25/2013)
Say you have a table of sales you could partition on sales date, so have one file per year.Performance would be better for queries in that time period
Partitioning is...
March 25, 2013 at 7:23 am
Another article making blanket statements without explaination .... 🙁
Multiple filegroups - maybe. Not always. Two reasons.
Split for performance - requires that the DB is IO bound to have any effect...
March 25, 2013 at 7:03 am
abitguru (3/25/2013)
March 25, 2013 at 6:57 am
McSQL (3/25/2013)
ALTER INDEX...
March 25, 2013 at 6:27 am
abitguru (3/25/2013)
GilaMonster, Can I prevent lock escalation with (LOCK_ESCALATION = DISABLE) ?? So sql not escalate (only in this table)
You can. So you'd prefer SQL to run out of lock...
March 25, 2013 at 6:25 am
Viewing 15 posts - 13,741 through 13,755 (of 49,552 total)