News

Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...
Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging ...
Does anyone here know of a way to view the tranaction log in sql server 2000? I know you can use lumigent log explorer but I don't want to pay for a product that will allow this.
Troubleshoots the issue where transaction log file grows continuously for databases with In-Memory OLTP enabled in SQL Server 2022. If you restart the SQL Server instance, you might notice the ...
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 with a ...
I'm considering dumping our transaction logs to disk more frequently/truncating our logs more frequently. We don't provide up to the second-last successfull transaction restoration in this particular ...