Nice one, thanks David. At least, I'm again reminded of the conversions. 😉

The same results gives also the function TRY_CONVERT.

Nice one from the category Resource Governor, thanks Junior.

I very much appreciate a good explanation and detailed

references to the RG sub-components. 🙂

Nakul Vachhrajani (8/10/2016)

---

Here you go: "Writing Pages"...

+1

The Article from Igor Micev referred to above is interesting. Some more details are e.g. here:

https://blogs.msdn.microsoft.com/sqlcat/2016/08/03/changes-in-sql-server-2016-checkpoint-behavior/

Nice question and a very good detailed explanation, thanks Kenneth. 🙂

The key to the correct answer is the ROLLBACK.

https://msdn.microsoft.com/en-us/library/ms181299.aspx

I'm sorry, after several run the script everything is correct, which is seen from the results,

that I'm sent from above. I don't even want to believe... 🙂

Interesting question, thanks Steve. But I would like to note that the result is not correct,

because DATABASEPROPERTYEX('dbname', 'IsClone') will return NULL if the database

is generated by using DBCC CLONEDATABASE...

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.