225 reputation
18
bio website webfirmary.blogspot.com
location Manila, Philippines
age 30
visits member for 2 years, 4 months
seen Apr 6 at 12:21
Hello There

Apr
10
comment Shared locks taken under Read Committed Snapshot Isolation (RCSI)
may i also ask, does sql server place shared locks on records if there is no index even if read_committed_snapshot is turned on?
Jan
24
comment SQL Server Error 833 On LDF File
yes, it is autogrowth 10% enabled, and it is currently at 70gb already...... will shrinking the ldf file help me?
Jan
23
comment SQL Server Error 833 On LDF File
the question i have is, why did the SQL Server restart suddenly solve the issue? and why was it only pertaining to the LDF file? Not any other files, I think there was some sort of issue with my LDF file. Is it because it has grown very large?
Jan
23
comment Oracle Active Session Pool Questions
thanks sir john
Jan
23
comment How to partition the table, week-wise?
nice answer. i've done this in informix as well.
Jan
23
comment SQL Server Error 833 On LDF File
hi thanks for the answer, however, what we don't understand is after restarting the database, the errors were gone. why did it need a restart? It also happened during the time that no one was using the system.
Jan
2
comment SQL Server 2008 R2 - Deadlock Trace, Need Help Understanding It
Am I having a deadlock on a single key? or am I getting deadlock on the hobt, need help on this one. Btw, the deadlocks are happening on multiple update statements updating a particular table.
Jan
2
comment SQL Server Select Count READ_COMMITTED_SNAPSHOT QUESTION
thanks, yup, need to use where clause for the statement
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
comment How to force the use of row locks?
thanks a lot, it worked