whenriksen (10/31/2016)

---

Phil Parkin (10/30/2016)

---

in this case, for queues of SSIS packages waiting to be executed, within different ETL jobs.

The volumes I am dealing with are much lower than yours and...

philand3 (11/2/2016)

---

experts,

how to exclude the negative value in this OT calculation,

,CalcPart AS

(

SELECT

department,subdepartment,dutyhours,person_num, event_date, in_time, out_time, minutes,day,friday,saturday,

ROW_NUMBER() OVER (PARTITION BY event_date, person_num ORDER BY in_time) AS daypart

FROM Prep

)

,tmpResult as

(...

rjaye03 (11/2/2016)

---

We have just encountered what appears to be suspect data in a lot of our SQL databases that house backend data for internal and external websites. For the...

matej_grabnar (11/2/2016)

---

I have SSMS RELEASE 2016.5 installed. Tried reopen/reinastall - I even did format & reinstall Windows 10 (with like 1 month of great SQL working connections)

I have no...

hoseam (11/2/2016)

---

I have

which gives me INT value of 72226, and I want it to include the...

Is that because you have set...

GA_SQL (11/2/2016)

---

Adding space to the Database , when the db is 75% full

here i done some script for finding free space

select

s.FILEID AS...

matej_grabnar (11/2/2016)

---

After upgrading from Windows 7 to Windows 10 - and after some updates of windows a very slow connection (10 - 20s) to SQL server accrued.

Queries are executing...

Telling us that something is "not working" is most unhelpful. Please elucidate.

BOR15K (11/1/2016)

---

Sadly you're right - every new customer starts from 2 to...

SQL!$@w$0ME (11/1/2016)

---

What is the minimum .net requirements for installing sql server 2016 developer edition with polybase.

.net v 3.5, 4.5, 4.6, 4.6.1?

Also do I need to install the below?

Important Note:...

mitzyturbo (11/1/2016)

---

Thanks guys for the replies

John - I got it working using the method you outlined, I used LEAD instead of LAG

Massive improvement on the performance too

Now I just...

kyagi.jo (11/1/2016)

---

Yeah, spent like 2.5 days, and was running out of options before today; was worried we'd purchased a SQL server enterprise license and would be crippled by being unable...

kyagi.jo (11/1/2016)

---

I was using SSDT 2015 and building the solution, producing an ispac file, dropping it on the server, and running (double clicking) the ispac file, to deploy the project...

kyagi.jo (11/1/2016)

---

Second breakthrough - I can deploy the package with no issues through the SSDT UI, it is only the ispac file that is not deploying properly! Very odd, I...