It will be harder for data to save the world when people in power keep saying it's fake news!

Passing logic into a stored procedure sounds like a bad idea to me.

We probably have enough unused DNA in our brains to store petabytes of data, or more. Who's working on the interface?  😉

Maybe I'm asking this in the wrong thread, but can anyone tell me where I can find documentation on DBCC TimeWarp?  ;-D

I ran into a similar problem before importing thousands of files from an archive. I ended up setting up the package to only run for a few hours at a...

If you can't create more space on D then you can consider adding one or more disk(s) and either moving some of the files or creating additional database files on...

adonetok (12/6/2016)

---

How to create a loop to go through all fields, all cells to replace "," with " " (space)?

For example, there are 70 fields in a table ORDER.

For some...

Phil Parkin (11/18/2016)

---

I suspect that the ? is not a ? in the data ... it's some other non-printable character.

This code snippet shows that ?+ is no problem:

IF OBJECT_ID('tempdb..#test', 'U')...

Eirikur Eiriksson (11/11/2016)

---

andy.plumb (11/10/2016)

---

thanks for the reply, I tried that and got error:

Description: An error occurred executing the provided SQL command: "SELECT * FROM U_Observation WHERE UPDATED_DATE > DATEADD(YEAR-2,GETDATE())". Native...

peter478 (11/4/2016)

---

okay but what is better? to have 3 tables separated or create one table... but, than I must create 3 relationship...

Sounds like you're on the right track.

One thing you'll have to do is convert those DTS packages to SSIS.

There are tools that can help you convert these, but I recommend you don't use them. Take...

Phil Parkin (10/5/2016)

---

Eric M Russell (10/5/2016)

---

Phil Parkin (10/5/2016)

---

If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all...