Interesting question, thanks Steve. 🙂 With the maths I kind of got into a fight,

but at least I learned something new. 😉

Thanks David for an interesting question.:-)

Skipping FOREIGN KEY constraint at temporary tables in this script prevent the error:

"Msg 547, Level 16, State 0, Line 19

The INSERT statement conflicted with...

Thanks for Your post....

chgn01 (7/27/2016)

---

If I use #tbl for insert values, and use 'dbcc opentran' to see the active transactions, it give me

No active open transactions.

DBCC execution completed. If DBCC printed error...

Thanks Kenneth for the very interesting question and perfect explanations with references. 🙂

Really odd question, unreal. Proves that it is not easy to build up a QotD.:angry:

Thank you Steve, not only for the very practical question ,

but also for being reminded to do the installation of MS SQL Server 2014 SP2.

+1 😉

Thanks Steve and happy weekend to all.

+1

Very interesting is also this article:

http://sqlperformance.com/2014/04/io-subsystem/delayed-durability-in-sql-server-2014

+1

The question is interesting, the typos I don't mind, at least I learned

again something new. Documentation is at a good level. Thanks,...

It is good to occasionally repeat the useful things. Thanks Ben for a good question and sharing.:-)

Thanks Steve, a nice question for a good start into the new week. 🙂

+1

Thanks Steve. It's interesting, but not exactly an easy question. 😉 Here is another link to a clear and concise explanation:

https://blogs.msdn.microsoft.com/psssql/2015/03/06/does-rebuild-index-update-statistics/

Thanks Steve, for the interesting question, again I had to repeat the TL 🙂

Well it's described in this article:

https://www.sqlservercentral.com/articles/Administration/100856/

Thanks for your interesting note and the link. For the SELECT * you can use GRANT...