Viewing 15 posts - 1,246 through 1,260 (of 2,463 total)
urmarke (10/2/2010)
The issue hasnt been resolved but we've got a work around so its okay for now.
What kind of workaround ? any index or query adjustment ?
October 4, 2010 at 4:17 am
nadersam (10/4/2010)
NO.Locking mechanism work on row level --> page level ---> then table level.no on database level
this is lock escalation see these links
http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/17/lock-escalation.aspx
http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx
nadersam (10/4/2010)
October 4, 2010 at 4:02 am
Can you post exact error ?
October 4, 2010 at 2:25 am
nadersam (10/3/2010)
1. Locking tempdb (is whole db locked) meaning no one can access table indexes.
NO.Locking mechanism work on row level --> page level ---> then table level.no on database...
October 4, 2010 at 2:13 am
Duplicate post . Answer on this link http://www.sqlservercentral.com/Forums/Topic997349-146-1.aspx
October 4, 2010 at 1:11 am
Jeff Moden (9/30/2010)
Topic options, print topic. No need to change settings.
Thanks Jeff .thats a bit better for lazy learning DBA like me 😀
October 2, 2010 at 12:03 am
sqlapprentice (9/30/2010)
Or another question, is it possible to use another configuration manager to connect to this server?
I am not sure about it, we can wait for another member for suggestion
October 2, 2010 at 12:00 am
Grant Fritchey (9/30/2010)
sp_helpindex exposes only orderable index columns; therefore, it does not expose information about XML indexes or spatial indexes.
So the short answer is,...
September 30, 2010 at 6:49 am
can you see them in local box's mgmt studio ?
September 30, 2010 at 6:44 am
Google for "RECOVERY MODELS" , there you can find useful information about these three terms.:-)
September 30, 2010 at 5:26 am
UMG Developer (9/29/2010)
September 30, 2010 at 5:22 am
Thanks a lot kingston ...can u brief about EXECUTE sp_executeSQL @query, N'@Count INT OUTPUT', @Count OUTPUT basically the OUTPUT parameter.
September 30, 2010 at 1:49 am
I would say , you yourself should test it with small data set and then you can see the result with different tweaks in the query.and If still you find...
September 30, 2010 at 1:40 am
removed
September 29, 2010 at 4:47 am
RTendo (9/29/2010)
One of my maint plans is failing due to permissions on an index!
Permission issue with index ???:unsure:
September 29, 2010 at 4:38 am
Viewing 15 posts - 1,246 through 1,260 (of 2,463 total)