Tag Info

New answers tagged

2

The best way to do SQL syntax checking without actually writing data is using the engine BLACKHOLE, which is the MySQL equivalent to UNIX /dev/null. A its name suggests, it is an engine that accepts all (but invalid syntax) but stores no data. Great for testing, and incredible inserting performance :-) Aside from that, people test setups by creating slaves ...


0

something like this? you explicit can disable the auto-commit mode http://php.net/manual/en/pdo.begintransaction.php


2

There is one entity - financial transaction, that can be in a various states. Completed, scheduled, postponed, rolled back etc. State is the property of the entity, only part of the whole, like the field is a part of the row. When the state is just a field of the table it is possible to create DB structure and code that are invariant regardless of how many ...


1

You are right to wonder. When you have an entity that can take two states (let's call them A and B) where one transitions directly into the other, but not the other way around, you should generally implement it in two tables. The reasons splitting into two tables is a good idea is: If A always transitions to B, then you will have a lot more B than A. This ...


1

Interesting question! Short answer: no. Long answer: there does not appear to be any existing way to get a list of savepoints defined. Even worse, it doesn't seem possible to create a PostgreSQL extension which would let you do this: looking at src/backend/access/transam/xact.c, you can see that functions like RollbackToSavepoint (which is where that "no ...


2

LOG_REUSE_WAIT_DESC will show LOG_BACKUP any time there has been at least one transaction that has not been backed up (when the database is in Full Recovery mode). You can see active sessions, requests, and transaction count for each session, by looking at the results of this query: SELECT SessionID = s.session_id , HostName = s.host_name , ...


0

You could declare a table variable, insert to that rather than printing and dump it in toto at the end of your process: declare @message table (i int identity(1,1), words varchar(100)); The identity column will keep things in chronological order. @tables' contents survive a rollback so are preferable over #tables or normal tables for this purposes. I ...


1

considering first question as a base: If I do not have any Transaction and as per schedule if Transaction Log Backup job run will it create any Transaction Log Backup files and can I skip those files, if there are not any transactions Yes of course it will create a transaction log backup file. backup job has nothing to do with whether any activity is ...


6

would there by any TR Log Backups for that time period? If there is no activity at all, there would be not transactions. But there is no harm in taking that backup as a part of your backup schedule (which is every 15 mins). It will look like - /*Processed 0 pages for database 'logbackup_test', file 'logbackup_test_log' on file 1. 100 percent ...


11

I haven't managed to reproduce this after running your code a few times. I presume that it must happen when a later row gets inserted onto an earlier page in the file though. So the order of operations is (for example) Rows inserted into heap on pages 200, 207, 223 Select statement starts and performs an allocation ordered scan. Finds that the first ...


1

SQL Server 2014 now resets the isolation level of pooled connections for most TDS protocol versions. Previous SQL Server versions did not reset the isolation level.


0

Actually this is the concept of explicitly and implicitly transactions. In explicit mode user need to start\Stop a transaction and are batch level scoped transaction. Whereas implicit transactions is automatically controlled by Server Engine and are statement level scoped. Server engine starts a new transaction after the current transaction is committed or ...



Top 50 recent answers are included