I understood the situation to be the opposite--e.g. ANSI_NULLS is OFF by...

Didn't know ROUND() could do this, but once I looked it up in Books Online it seemed fairly straightforward--I learned something today, which is always nice!

Isn't ANSI_NULLS set to OFF by default? So the behaviour in this article will only apply if you've explicitly set it to ON. I'd have thought that deserved more than...

Really?

I was under the impression that a BLOB is stored as a string of binary numbers in a database and then the software converts it for use, therefore saving a...

Not to mention, of course, that this 5-20Mb per customer may well not be spread evenly over the whole day--if you get a whole bunch of them trying to upload...

There is sometimes a HUGE performance penalty (2:1) to be paid for using VARCHAR(MAX) depending, of course, on what you're doing. Correct sizing is always important. I'd dare...

Also our situation might be a little unique. I'd say that 99% of our clients are located within 400 miles of the main office. And 100% are in...

No, that's definitely not right. Encryption will make the data larger, but that's only because encryption algorithms usually have a fixed block size to deal with. For 128-bit encryption that...

Well, you're asking on a forum dedicated to Microsoft SQL Server. What answer do you think you'll get? 🙂

I would agree. Log shipping is already essentially a means of backing up the database--if you're doing that *and* taking full backups of the primary you should be in good...

another reason i was thinking iMac is that it's UNIX and i have an almost 3 year old son and thought it would be better to start him on a...

chrisph (8/18/2010)

---

Thank you Steve. So what you are saying is this option is feasible but must be selective. For instance we could save space by converting a 50MB...

That must be a pretty small external drive if it's formatted as FAT32! Is there any particular reason you can't reformat it as NTFS?

Only problem there is that sometimes the "human check" part can involve almost as much work as just doing the job manually in the first place! Testing is actually one...

Well, it's not quite like that...when you drive the DSG car in manual mode it's a sequential gearbox (like motorcycles and F1 cars), so you just tap the lever forward...