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

Outstanding! [sarcasm]

OK, could it somehow be a permissions thing?

How are you executing the...

subrahmanyam113 (11/1/2016)

---

Hi I am using a script to get details about database name, schema name, table name, row count and size of each table in GB. I would like to...

kyagi.jo (11/1/2016)

---

Thanks, there are still avenues to explore...

The reinstall of SSIS did not help.

I tried to make the script task in VB, no luck.

I tried the package deployment...

SteveD SQL (11/1/2016)

---

Hi,

SSIS 2008 R2 packages

The scenario is I am importing data from a file into a table which has a foreign key field which is optional. The foreign key...

kyagi.jo (11/1/2016)

---

I got the server updated, but still no luck.

It is now: Microsoft SQL Server 2016 (RTM-CU2) (KB3182270) - 13.0.2164.0 (X64) Build 9600

Looking at the previous versioning, this...

DamianC (11/1/2016)

---

Finally working

Thom A, misunderstood your example part

Set the expression of the variable to

"SELECT COUNT(*) AS recordCountDestination FROM " + @[User::tableName] + ";"

Also set the property EvaluateAsExpression to True

Remove any...