That's what she said 😛 (http://www.nbc.com/The_Office/)

I am your fearless leader, plowing ahead blindly in the fields of DBA fiefdom. Now let's get back to work.

Sorry for the delayed reply,...

you're welcome and we're trying to sprinkle in some 2008 ones for more information.

the "Select all" has been removed.

I think Grant and Jeff must be related to Dwight Shroot. Sorry you guys lost your privileges to bring nunchakus and stars into the office.

Sorry, wrong tick on the answers. This has been corrected and points awarded back.

The question has been edited to say in-row storage.

My opinion is that looking at LOB storage is storage outside the row, and it shouldn't be used in terms of...

Nice

It would need enough space, but you're not necessarily backing up the entire server. It doesn't really make sense to back up anything other than the database and log backups...

The contractor is not a bad idea if the workload is large. And you'd want to think about this creatively. You might hire a contractor to do someone else's job...

Wow, you are very welcome, and I appreciate the comments.

Note that it wasn't all me. Andy Warren and Brian Knight started this site with me and worked hard for years...

Glad to see that there are places that recognize the value of teamwork and that need for people to pull together. I'd like to think it's that way more places...

Other responses here: http://www.sqlservercentral.com/Forums/Topic535907-359-1.aspx

Please do not cross post.

I agree with Jeff, we're happy to help, but we'd like to see a try.

GROUP BY, maybe include a HAVING clause for the COUNT() of records for a patient.

Schemas are a way to separate out objects and assign permissions. You could have all stuff moved into one of two schemas, which would make production administration easier.

You still have...

I think you need CONTROL permissions on the table (or all the tables) to do this.

I'm not sure how you can do this directly in SQL 2000. You could setup...

Most backup solutions only attach to one server and you send files from other servers to that one, or there is a backup agent that moves files.

Arcserve, Veritsa, BMC, all...