This will skew the value if the time zone is not UTC!

😎

VastSQL (8/2/2016)

---

Eirikur Eiriksson (8/2/2016)

---

VastSQL (8/2/2016)

---

Eirikur Eiriksson (8/1/2016)

---

Have a look...

Quick thought, datetime does not have any time zone awareness and only assumes UTC, convert into a time zone aware data type such as datetime2 instead.

😎

SELECT CONVERT(DATETIME2,'2016-08-01T07:04:24+01:00',127)

VastSQL (8/2/2016)

---

Eirikur Eiriksson (8/1/2016)

---

Have a look at Choosing a...

Without the TF 1117 the splitting of the tempdb into multiple files is likely to be an utterly useless exercise as the load will more or less end up in...

Quick thoughts:

This is normal and not much one can or has to do about this as the optimiser may skip explicit conversions and introduce implicit conversions, nothing says it has...

Quick example which should be enough to get you passed this hurdle. The sample creates date set and a week group identifier starting every Sunday and ending on the next...

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

-- DECLARE A DATETIME VARIABLE AND SET IT'S VALUE 03:31:35.2730000 BEFORE CURRENT DATE

DECLARE @LAST_RQ_TIME DATETIME = DATEADD(MILLISECOND,-12695274,GETDATE());

-- DECLARE A TIME(7) VARIABLE AND SET IT'S VALUE TO...

The answer is NO, objects only

😎

This does ring a bell but haven't used Enterprise Manager for a while. IIRC the SSMS and Object Explorer Details mainly use SMO, seen some funky sql sometimes for "Intelli"sense

...

Quick question, have you set the TFs 1117 & 1118?

😎

Do you have a PowerBI or Power Pivot sample data / model?

😎

Quick question, what is the current storage configuration?

😎

Have a look at Choosing a Recovery Model for...

Messi (8/1/2016)

---

Eirikur Eiriksson (8/1/2016)

---

Quick question, can you post the DDL (create table) for the tables, sample data as an insert statement and the expected result set. This problem is trivial...