I would agree with scripting things. I'd script out all jobs and then search/replace.

I would vote for the WROX book as a good place to start.

There is no easy way to do this. A database isn't like the file system where you search everything. A search across different tables requires different queries with separate FROM...

use a max() aggregate and a group by clause.

It's fairly simple, but it almost seems like this is homework. Try it yourself.

I see NULL mostly as a "we need to get this data" marker. We don't know why it's not there, don't know what's there, but we need something.

No, I don't think there are big issues. SQL Server is designed to handle files, even large ones. I think that you have some limitations around 2GB, but apart from...

Implement logging, read the logs. They will provide more information

I don't think we completely know what happened. That would be limited to a few people, but I think most reports agree he did not disclose passwords when asked, and...

Thanks for the vote. I would decline to serve.

As good a word (phrase?) as any.

I shall decline to post my word for the day

:w00t:

Thanks, Alvin. Appreciate the kind words.

Thanks. I shall decline to comment on PASS further at this time.

256kb, should be in SQL, above 1MB, should be in the file system. I think it's a gray area in between.

You might reduce some SQL resources/IO from a large file,...

If you can be sure that it will always mean N/A, you could use it. Alternatively, you could use a code, something like 99989 to mean electric car.

It's how you...