Thanks Steve, a good opportunity to repeat the Query Hints.

I can't forgive join this beautiful article from one gentleman

who was recently as a subject in the QotD. ...

Thanks for an interesting question Steve.

The reference MSDN catalog.start_execution (SSISDB Database) gives only an example

with the parameter N'LOGGING_LEVEL'. The use of other parameters is well explained here:

http://sqlblog.com/blogs/andy_leonard/archive/2015/11/04/the-synchronized-ssis-execution-parameter.aspx

or here:

http://www.ssistalk.com/2012/07/24/quick-tip-run-ssis-2012-packages-synchronously-and-other-execution-options/

Hmm, interesting, numeric_expression 0.5 - 0.9 cannot be with the ROUND function directly rounded.

SELECT ROUND (0.4, 0);

SELECT ROUND (0.5, 0);

Results

---------------------------------------

0.0

(1 row(s) affected)

---------------------------------------

Msg 8115, Level 16, State 2, Line 9

Arithmetic overflow...

Thanks Steve for this good question. Quite it was useful to repeat

a little something from the SQL Server Security Functions.;-)

RonKyle (9/6/2016)

---

What could have thrown me was that I though ET was 5 hours off GMT. ET is five hours behind time in England and 6 in central Europe....

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