paul.knibbs (8/24/2016)

---

Got the wrong answer, but that's because I pretty much clicked at random...I wanted to know the actual answer and my Google-fu failed me in finding it. Odd that...

Thanks Steve for this question. It wasn't quite simple...:-)

An interesting problem of differences in the rounding of the data type float

vs. numeric is possible to see if you run this...

+1

And thanks Sergey for good explanation. 🙂

Thanks Steve for this question, interesting is there a more things, such as

DBCC CLONEDATABASE is only for version SQL Server 2014 SP2.

In SQL Server 2016 is not yet, or...

The Dixie Flatline (8/18/2016)

---

George, I read and understand what you are saying, but I have run the queries multiple times with ANSI_NULLs OFF and ANSI_NULLS on. ...

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