Question : Trying to keep rows consistent then referencing previous rows. CREATE TABLE transactions ( id int PRIMARY KEY GENERATED […]
Tag: consistency
what is an Assert in Database world?
Question : I searched for Assert and found general explanations: Assertion (software development) In computer programming, an assertion is a […]
Data inconsistency prohibition if a table refers to another via two many-to-many relationships
Question : I have following database design (by => foreign key constraints are depicted): Company[id] CompanyRealm[id, company_id=>Company.id]many2many Project[id, company_id=>Company.id] ProjectRealm[id, […]
Optimize queries that need to be 100% ACID compliant but can tolerate latency in persistence
Question : Introduction I’m writing a trading program in C++. The program involves having user balances and orderbooks. The orderbook […]
Optimize queries that need to be 100% ACID compliant but can tolerate latency in persistence
Question : Introduction I’m writing a trading program in C++. The program involves having user balances and orderbooks. The orderbook […]
SQL Server backup versus third party snapshot based backup using VSS
Question : Is it safe to assume that SQL Server instance or database level backup to a NAS share or […]
How can I generate a consistent entity graph (say from 10 tables) from a database fetch
Question : Suppose I have many tables in a database that need to be joined together to get a single […]
DBCC CHECKDB consistency-based I/O error
Question : Running: DBCC CHECKDB(DatabaseName) with NO_INFOMSGS gives me the following error: Msg 824, Level 24, State 2, Line 1 […]