That Grant is "really lazy" and Scary DBA, evidenced by its rich publishing

activity and his excellent book "SQL Server Execution Plans" and more.

So let his laziness will continue, we...

I do not regret that I have got it wrong. I learned something new, thanks Andy. 🙂

The question has been imprecise specified, because only SQL Server Enterprise Edition

supports Data...

+1;-)

Interesting question, thanks Sergey 🙂

I didn't have it easy, but I learned something new, thanks Steve.

Qotd from 2016/08/31 was brilliant, because all the first three answers were right... 😉

The first error was, that...

The question is worded imprecise, and possible answers do not match with

the documentation listed in the reference. I guess it may be in the thorough

preparation for the vacation, all...

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