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

The first shop to stop in for this kind of problems is SSIS, Sql Server Integration Services.

😎

Quick question, which version of SQL Server Migration Assistant (SSMA) are you using and does it support the Oracle version in question?

😎

For more information on SSMA, have a look at...

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 but in order...

BLOB_EATER (8/1/2016)

---

Eirikur Eiriksson (8/1/2016)

---

Thanks for this fine piece Daniel!

😎

My thought is that there are many out there which have Azure SQL databases but don't have local SQL Server instances to...