Missing Indexes, Lazy Spools and Undocumented Flags

Now, lets start with the fact that Spools are awesome! Who doesn’t like free indexes stored in the tempdb? The whole idea about that spool operator is that it consumes a set of data and stores it in a temporary structure in the tempdb in order to be reused. However, they could be expensive! The… Continue reading Missing Indexes, Lazy Spools and Undocumented Flags

SQL Server Advanced Nested Transactions in Nested Procs

Hello Guys, As many of you have probably already experienced the pain of having to deal with multiple transactions in nested procedures, I overcame the problem with the following solution so thought I’d share it with you guys! As we have 2 procs: 1 Inner and 1 Outer( you can have as many as you… Continue reading SQL Server Advanced Nested Transactions in Nested Procs