Viewing 15 posts - 47,146 through 47,160 (of 49,571 total)
Jeff Moden (3/21/2008)
Regardless of what the cause of the deadlock is, I guarantee it's going to be code that has a BEGIN TRAN/COMMIT in it...
The other place to look...
March 21, 2008 at 2:32 pm
Matt Miller (3/20/2008)
Jeff Moden (3/20/2008)
No... like I said earlier... WITH (NOLOCK) only affects SELECT's. The following is from Books Online... (or are we talking something different?)
NOLOCK
Do not issue...
March 21, 2008 at 2:26 pm
Are there any errors in the error log?
Without knowing more about why SQL's marked the database suspect, it's impossible to suggest an appropriate course of action.
March 21, 2008 at 2:06 pm
Adam Haines (3/21/2008)
You can also query msdb for suspect pages.SELECT * FROM msdb..suspect_pages
On SQL 2005 only.
Palwi: Questions related to SQL 2000 should rather go into the sql 2000 forums. Otherwise...
March 21, 2008 at 2:01 pm
Generally, in my experience, if the code is written optimally and the indexes are well designed, there's little need to fiddle with the locking mechanism.
Are you seeing lots of blocking?
March 20, 2008 at 7:36 am
I would suggest you run profiler during the peak period to see what queries are running long, or doing lots of IOs.
Once you've identified the slow running or resource hogging...
March 20, 2008 at 6:48 am
The last wait time is a scheduler yield, but from what I can see, the curent wait type is 0 (0x000) and the wait time is 0. Hence the process...
March 20, 2008 at 5:31 am
Not sure about the second and third.
1st probably uses the base table rather than the view because the column Salary isn't in the view, hence a scan of the...
March 20, 2008 at 5:06 am
For not null, it'll be an ALTER TABLE <Table Name> ALTER COLUMN ...
The other two will be forms of ALTER TABLE <Table Name> ADD CONSTRAINT ...
If you look up ALTER...
March 20, 2008 at 1:15 am
Pavle (3/19/2008)
March 20, 2008 at 1:03 am
Which edition of SQL 2000? (Enterprise, standard, ...)
I was asing what the definition code for your indexed view is. (Create View ....)
March 20, 2008 at 12:57 am
Only if you don't mind potentially getting wrong data from time to time.
Nolock allows reading of uncommitted data. Also, because of the way it's implemented, there's a chance of missing...
March 20, 2008 at 12:54 am
DTS packages
Linked servers
Server-scoped DDL triggers
March 20, 2008 at 12:42 am
What edition of SQL are you using?
What's the indexed view's definition, and what does the query look like?
March 20, 2008 at 12:23 am
Viewing 15 posts - 47,146 through 47,160 (of 49,571 total)