if your SSD is getting hung up, depending on the cost, it might be charper to RAID 0 a couple of cheap SATA3 SSDS than use a PCIE...

Henry_Lee (10/14/2016)

---

My home lab has been invaluable over the years, for all sorts of reasons. One of my favorite reasons is to "proof of concept" a task I may need...

I spin up VMs on my gaming machine when I want to do home lab stuff -

32 GB Ram, i7 4790k, 512 GB SSD, 5 TB spinning Rust. ...

Ok. What exactly is ANSI padding?

Eric M Russell (9/26/2016)

---

Steven.Grzybowski (9/26/2016)

---

A locked box.

Inside that locked box is medication. Lots and lots of medication. My regularly prescribed daily meds, every OTC NSAID you...

A locked box.

Inside that locked box is medication. Lots and lots of medication. My regularly prescribed daily meds, every OTC NSAID you can think of, allergy...

I wish I could. The problem...

drew.allen (9/14/2016)

---

Clean up your data before submitting it to your function.

DECLARE @input VARCHAR(250) = 'abc,def,ghi,123,jkl,345,678,mno,901,234,567,pqr'

WHILE PATINDEX('%[0-9],[0-9]%', @input) > 0

SET @input = STUFF(@input, PATINDEX('%[0-9],[0-9]%', @input) + 1, 1, '')

You should also...

That was a typo, I meant cross apply, and as far as modifications, it just had to do with different table schemas than what I posted here- more fileds than...

Luis Cazares (9/2/2016)

---

Maybe this could help.

CREATE TABLE Customers( id int, Point Geography);

INSERT INTO Customers

SELECT 1, geography::STGeomFromText('POINT(-122.34900 47.65100)', 4326);

CREATE TABLE Stores( id int, Point Geography);

INSERT INTO Stores

SELECT 1, geography::STGeomFromText('POINT(-125.34900 47.65100)', 4326)...

If I am not following the guidelines exactly, I apologize, I am blocked from seeing that article at my workplace.

--Sample Tables

CREATE TABLE Customers

(CustomerID BIGINT, Customername varchar(50),...

If you are looking for closest to the start date or end date, you could just use a query to identify all the records that are between them, and then...

Fixed. Issue was related to run64bitruntime getting set to true.

Thank you. The environment settings in SSIS are great.

Add the OPTION (OPTIMIZE FOR UNKNOWN)