This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hello. I'm looking to insert a large set of data into a primary table but then n number of data subsets related to the primary data into a secondary table. Are there any known limits on the number of SQL inserts allowed if i wrap it all into a single transaction? Thank you.
I have used transactions which contain several thousand records with SQL Server. But why don't you try out your proposed application with your proposed database to see what actually happens? It's called "stress testing".