julienchappel 38298 (12/13/2015)

---

Hi Steve,

Which is your right piece of code:

A./

CREATE TABLE MyTable

( myid ID

, myFS varbinary(max) FILESTREAM

);

go FROM THE SQLServerCentral.com <subscriptions@sqlservercentral.com>

OR

CREATE TABLE MyTable

( myid INT

, myFS varbinary(max) FILESTREAM

);

go

from THE...

Take this week's survey. don't look anything up, first thing that comes to mind. Be serious, not silly.

https://www.surveymonkey.com/r/JGFCKDW

David.Poole (12/11/2015)

---

Given that data is committed in an operational system and that commitment process plays no part in the confirmation of delivery to the reporting process I'd say that eventual...

Search automatic restore, or restore all files here. Lots of scripts that you can use or might help you with a base to modify.

ID is probably a bad idea. I was thinking a UDDT, but I should have left is as an INT.

Changed.

Does the table exist and is used for a long time or just a bit of work?

Short answer, add indexes if they speed up queries more than the time things...

Gary Varga (12/7/2015)

---

It seems to me that the established professions either have a more rigorous framework for estimation and change control (e.g. construction) or have expectations of the unknown accepted...

Friday

Honestly, the reapply all logs up to today, without getting another full backup just won't work. You'll eventually have too much work to do overnight and it's too brittle.

First, you...

I agree with both above. An ODS just tends to be a central data warehouse where you've consolidated data, cleaned/standardized, and then often feed other systems. I've seen a few...

Excellent

If you pulled the data directly into a data reader and then processed that down on the client, is that faster?

ccd3000 (12/10/2015)

---

I think we're alchemists (most of us anyway) in terms of where we are in the profession's evolutionary development. Others in this thread have astutely pointed out that we...

cjb110 (12/10/2015)

---

Yes we are, and are we striving to reach the same standards as physical engineering, yes I think most of us are.

I think that article was a disservice to...

Manic Star (12/10/2015)

---

We're janitors.

We clean up the place, take out the trash and keep the mechanism humming along with regular maintenance that no one sees, appreciates or cares about...