The advantage of using one connection for multiple statements is that it reduces the overhead of establishing multiple connections, while allowing multiple statements to access the database. The ...

What do you do when you can't avoid huge transaction logs in SharePoint and your files are too large? Last month, I wrote about how to avoid having ginormous transaction logs within SharePoint ...

Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

i have this problem with the sql server ver 6.5 ( i know i need to upgrade but $$ is not so kind to me at the moment :0)). how to increase the Log size of a database (no.. not by expanding the ...

A database start up, NuoDB, reached out to me to talk about a project they were working on to address the need for extremely scalable, web scale, transaction oriented database engines. The ...

The MongoDB 4.0 release introduced multi-document transactions to the popular open source NoSQL DB. The lack of a transactional capability has been a key limiting factor in MongoDB uptake, so it’s not ...