This is the sensible option. I had to do it last Thursday when...

By default, yes, but not necessarily.

Kannan Vignesh (1/8/2017)

---

Folks,

Hav a good day.

i need a clarification regarding usage of checkpoint in SSIS.

i set a checkpoint for single task. in this task , trying to insert a 1000...

OK, here is some code which may help you. It won't run as it stands, but it might help you understand how I got data back from Facebook using OAuth.

Firstly,...

Do you have a question?

JasonH-ITG (1/6/2017)

---

Nope, not in my case; it had persisted between restarting SSMS and reboots. It was only occurring on one of my servers; workstations and other servers did not...

WITH cte

AS

(

SELECT tbl1.Date, tbl1.ID, tbl1.Order_Amount, tbl2.StoreNum, ct = COUNT(tbl1.id) over(partition by tbl1.id)

FROM tbl1 right join tbl2

ON tbl1.ID = tbl2.ID

)

SELECT * FROM cte

WHERE ct > 10

I suspect the problem was...

JasonH-ITG (1/6/2017)

---

Sorry for replying to an old post, but THANK YOU! This fixed the issue for...

mikevessey (1/6/2017)

---

hey,

nobody said you had been tripped up... in fact I said that I had been tripped up before

in sql 2000 days people always said PHYSICAL storage order. most...

mikevessey (1/6/2017)

---

I've been tripped up by this before too

The key point is PHYSICAL .

A clustered index does not determine the order it is stored on disk.

I went to a...

Phil Parkin (1/6/2017)

---

On your SQL Server instance, in SSMS, go to

Server Objects/Linked Servers/Providers and check which version of the ACE driver appears there.

Assuming version 16 is there, try running...

On your SQL Server instance, in SSMS, go to

Server Objects/Linked Servers/Providers and check which version of the ACE driver appears there.

Assuming version 16 is there, try running the export...

RonKyle (1/6/2017)

---

SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is if...

mikevessey (1/6/2017)

---

lets be clear on that point....

a clustered index does not prevent duplicates

a primary key (normally also the clustered index) or also a unique constraint will prevent duplicates

the clustered index...

John Magnabosco (1/5/2017)

---

I am working on an ETL process which pulls from several APIs. Essentially, I capture the JSON output and then leverage OPENJSON to parse the output. I have...