The TIFF file should be in a binary format (binary or varbinary). This means you need to extract the binary data and write it to a file.

I'm guessing that...

The answers have been updated, and I'm awarding back points to this time.

Steve

A backup is copy of the pages. There is no effort made to recompute anything or look at the contents. They are copied to disk on backup, copied back on...

The main reasons have been listed. Using normalized storage gives you slightly more complex queries with joins, but easier updates, easier and simpler growth if you expand the model, less...

I know, lots of management doesn't. However devs still get value. Write the tests to exercise your code, so that when you alter it, you know if it still works.

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

The R or Python stuff is useful if the statistical work is more complex. Most of what can be done in R can easily work in Python, which is a...

Insert is a modification. In this case, you shouldn't have collisions, but there are ways to handle things. I'd urge you to look at replication.

Eric M Russell (2/23/2016)

---

Assuming you could load GB of disk storage, GB of RAM, Windows, and SQL Server, a Raspberry PI would be severely under powered for even single user...

kiwood (2/23/2016)

---

I think the government needs to do the right thing and get involved in the hospital's operations for awhile. It should start with a fine for not having things...

philcart (2/23/2016)

---

We've been hit with CryptoLocker 5-6 times already. Each time it's been a network share in one of the branch offices that's been affected.

The Infrastructure guys here have become...

If you have collation conflicts, then add a collation statement to the queries to resolve things. That's better than wrapping queries in this try..catch.

Here's an example: http://www.sqlservercentral.com/articles/Administration/collate_part1/875/

Can the table be changed on any node, or is there a master table that controls writes?

It's easier if there is a master, but you can implement Peer to Peer...

There would be a table for grades. ZZMartin provided an example.

The idea here is to not get locked into changing tables constantly. You should have a table for the subject,...

As Jamie wrote. Have a specific, curated set of data. Know the opening state, make the change, query for the end state, which you should know.

To do this right, you...