Interesting question, thanks Bob. SET ANSI_NULLS OFF does not eliminate the column

with the value NULL, therefore, Query1 returns 7 rows. Below I present a fragment

of the example from the...

The wording " What's the maximum time that can be stored in SQL Server 2014?" got me. :angry:

But logically speaking, isn't it the interval from zero to 2079-06-06 23:59:00

the maximum...

ako58 (8/16/2016)

---

http://www.sqlservercentral.com/questions/Foreign+Keys+(FK)/144670/

CREATE TABLE #TableTest1 (

ID INT NOT NULL,

CONSTRAINT PK_ID1 PRIMARY KEY(ID)

);

CREATE TABLE TableTest2 (

ID INT NOT NULL

CONSTRAINT FK_TableTest1_ID FOREIGN KEY (ID) REFERENCES #TableTest1(ID)

);

INSERT INTO #TableTest1 (ID)

VALUES

(1);

INSERT INTO TableTest2 (ID)

VALUES

(2);

select *...

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. 🙂