230 reputation
110
bio website webfirmary.blogspot.com
location Manila, Philippines
age 30
visits member for 2 years, 9 months
seen May 29 at 15:11
Hello There

Jan
2
comment SQL Server Select Count READ_COMMITTED_SNAPSHOT QUESTION
thanks, yup, need to use where clause for the statement
Jan
2
asked SQL Server 2008 R2 - Deadlock Trace, Need Help Understanding It
Jan
2
comment SQL Server Select Count READ_COMMITTED_SNAPSHOT QUESTION
I'm using read_commited_snapshot isolation level. I turned it on as i'm using the read_committed by default. I'm just interested if locks are being placed during select counts. Thanks, I've already placed indexes btw
Jan
2
comment SQL Server Select Count READ_COMMITTED_SNAPSHOT QUESTION
actually, I only need to know if shared locks are being placed. I'm trying to investigate a deadlock issue. Thanks
Jan
2
awarded  Editor
Jan
2
revised SQL Server Select Count READ_COMMITTED_SNAPSHOT QUESTION
added 22 characters in body
Jan
2
asked SQL Server Select Count READ_COMMITTED_SNAPSHOT QUESTION
Jan
2
comment How to force the use of row locks?
thanks a lot, it worked
Nov
26
asked How to force the use of row locks?
Dec
16
awarded  Supporter
Dec
16
awarded  Scholar
Dec
16
accepted Oracle Script For Getting Long Active Sessions
Dec
7
asked Oracle Active Session Pool Questions
Dec
7
asked Oracle Stopping - Can't Login All Of A Sudden -
Dec
6
awarded  Student
Dec
5
asked Oracle Script For Getting Long Active Sessions
Dec
5
awarded  Autobiographer