All 100 transactions are nested transactions. That means the only "real" transaction is the first one. Until the very first transaction is committed, nothing is "really" committed.

With a nested...

My first exposure to SQL Server was with an application that made extremely heavy use of database trigger, they stored an awful lot of application logic in them. Because we...

As much as I look forwards to SQL Server being on Linix, I expect in 2017 forums covering aspects of the LAMP stack will be clogged up with posts along...

Steve Jones has a side career as carnival fortune teller.

https://www.microsoft.com/en-us/server-cloud/sql-server-on-linux.aspx

Indy Mike (2/15/2016)

---

I've come to understand that tables below a certain size will not use the indexes assigned to them, because the table is more efficiently joined by loading it...

I remember that Simon Sabin did an article called "Scalar functions are evil", but whenever I needed to send someone a link to it I'd Google for "Simon Sabin is...

The only rule of thumb I use is "rules of thumb are usually wrong"

They have not made a manual large enough with which to beat the developer / DBA who would create a table like this in Production.

the issue I have with the counter offer is that with a good boss / manager, the options available too you in the company should have been discussed before getting...

Even if a case can be made to not use Foreign Keys, you still have to live with "Low Tech Ley" wish to fragment the database into separate (micro)databases. Referential...

One thing to note straight out of the gate is that he doesn't specifically say the problem is Foreign Keys. Rather that his solution to his problem is to create...