Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window. Type the ...

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 ...

The introduction of increased transactional capability into non-relational databases makes sense-in the same way that providing SQL layers on top of Hadoop and many other non-relational stores makes ...

ACID, though, doesn't matter much when you're just reading data for analysis. And the database locks that SQL databases use to protect database consistency in transactions can get in the way.

The next version of Microsoft’s relational database management system (RDMS) promises to bring immense performance gains to online transactional processing systems. SQL Server 2014 will come ...

Get ready to scale out SQL Azure databases beyond today's 50GB limit with the Transact-SQL and ADO.NET elastic sharding features, which are coming in the 2011 SQL Azure Federation Community Technology ...

New Power for Developers With Oracle Autonomous Transaction Processing Cloud, developers get a new level of freedom to deploy the Oracle database at the moment their project calls for it ...