Reputation
373
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 10
Newest
 Informed
Impact
~9k people reached

Apr
27
comment SQL Server: update trigger fires before insert trigger
I think your answer might be found here: dba.stackexchange.com/q/468/15356
Apr
20
comment What is the impact of temporarily setting ALLOW_PAGE_LOCKS ON
SAP has some tables that have the ALLOW_PAGE_LOCKS = OFF set, which hampered our maintenance solution, so we just added these tables to the EXCEPTIONS list. :-)
Apr
6
asked What are valid connection strings for SSMS login box?
Apr
6
answered What are valid connection strings for SSMS login box?
Apr
5
revised How to restore a transaction log
Moved duplicate WITH clauses in the RESTORE LOG part
Apr
5
suggested approved edit on How to restore a transaction log
Apr
4
revised Can I rely on reading SQL Server Identity values in order?
added 530 characters in body
Apr
1
awarded  Informed
Mar
30
comment Can I rely on reading SQL Server Identity values in order?
No you cannot stop the statements, but my (slow) observation is what happens on a fast/normal basis. As soon as one SPID acquires a lock to insert data, the other one will be unable to acquire the same lock. The faster statement will have the advantage of having already acquired the lock and the ID in sequence. The next statement will receive the next ID after the lock has been released.
Mar
29
answered Can I rely on reading SQL Server Identity values in order?
Mar
29
accepted PostgreSQL Write Ahead Logs Archive Mode
Mar
29
comment PostgreSQL Write Ahead Logs Archive Mode
Yes, I would prefer an answer for DBAs and I don't know why you come to think I'm a poltergeist. I phrased my question pretty adequate, explaining what I have and what I understand is happening. Thanks for your time.
Mar
24
comment PostgreSQL Write Ahead Logs Archive Mode
WALs are stored in the /pg_xlog/ directory. The backup (or replication, copy, archive) thereof are stored in the directory specified in the 'archive_command'. I am trying to figure out how it should work if I were to use a backup of the archived WAL files together with a copy of the dump created with pg_basebackup. I'm not running a cluster, just using the WAL portion to have PITR capabilities. I guess if I would have left Simpana portion out I would have gotten better answers, but it is part of the equation I'm trying to solve.
Mar
24
comment PostgreSQL Write Ahead Logs Archive Mode
Thanks for your feedback. I probably just miss-phrased the question then. I understand what the WAL files are for and where they are copied to with the archive_command, I'm just not sure what cleans up when and why in the archive directory (see also comment below). I had a look at your link. Thanks. The link helped me figure out some of the internals. Please post your comment as an answer. I guess if I would have left Simpana portion out I would have gotten better answers, but it is part of the equation I'm trying to solve.
Mar
23
answered What version of SQL Server do I need for practice?
Mar
23
asked PostgreSQL Write Ahead Logs Archive Mode
Mar
23
answered PostgreSQL WAL recovery not working due to missing WAL
Mar
23
answered Which TLogs are causing large block change in SAN snap?
Mar
15
answered TSQL Script Execution Through Power shell, Special Characters Rendering Problem
Mar
4
awarded  Scholar