transactions

External Article

Transactions

  • Article

By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required incredible amounts of air conditioning, and perhaps more importantly, ran batch jobs submitted on punched cards and magnetic tape. But even before we had these dinosaurs, there were E.A.M (electric accounting machine) units.

2024-11-22

SQLServerCentral Article

Leveraging SQL Transaction Control in Python Applications

  • Article

Explore the fundamentals of Python's SQL transaction control, demonstrating how to control and enhance database operations for improved data integrity. The best practices and real-world examples for integrating strong transaction management in Python applications are covered in this article.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

2024-10-28

1,549 reads

Blogs

The Book of Redgate: Meetings

By

I think we might have forgotten this a bit, but on one of the...

New article: Automating SQL Server Builds

By

I refresh my test SQL Servers at least monthly with a fresh VM. Setting...

Leading with Accountability: How Extreme Ownership Transforms Leadership

By

Embracing Total Responsibility In every organization there comes a moment when teams must choose...

Read the latest Blogs

Forums

ssrs subscription file share

By jshumaker

I am trying to create a subscription that posts to a one drive directory. ...

What is Delayed Durability in SQL Server — And Should You Turn It On?

By Chandan Shukla

Comments posted to this topic are about the item What is Delayed Durability in...

Which MAXDOP?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Which MAXDOP?

Visit the forum

Question of the Day

Which MAXDOP?

I have a SQL Server 2022 instance with this setting: 

EXECUTE sp_configure 'max degree of parallelism', 4;
GO
I then run this: 
SELECT ProductID, OrderQty, SUM(LineTotal) AS Total
FROM Sales.SalesOrderDetail
WHERE UnitPrice < $5.00
GROUP BY ProductID, OrderQty
ORDER BY ProductID, OrderQty
OPTION (MAXDOP 2);
GO
What is the maxdop for my query?

See possible answers