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

Oct
3
awarded  Popular Question
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?
Apr
10
revised Shared locks taken under Read Committed Snapshot Isolation (RCSI)
added 48 characters in body
Apr
10
awarded  Yearling
Apr
10
asked Shared locks taken under Read Committed Snapshot Isolation (RCSI)
Mar
25
asked Why Am I Getting Deadlock - Please Read Trace
Jan
24
awarded  Commentator
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
awarded  Teacher
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
accepted Oracle Active Session Pool Questions
Jan
23
answered How to partition the table, week-wise?
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
23
revised SQL Server Error 833 On LDF File
additional info
Jan
23
asked SQL Server Error 833 On LDF File
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
asked SQL Server 2008 R2 - Deadlock Trace, Need Help Understanding It