I've seen references to nHibernate but not really sure which ORM. I've never heard of the application/ORM making schema changes. Now this Agile Development shop does do...

The application does use an ORM. What is being proposed by our Senior DBA is partitioning along with with a view using union all to cover the primary table...

Thanks Lynn. I'm not sure what will eventually shake out --- management is meeting on this today. DBA management seems to want a simple solution where data...

Thanks. I think my example was poor, but was trying to create a scenario where sql would attempt to put too much data in the file that had more internal...

I've been looking at all the various techniques for partitioning on sql 2005 and later, but my specific question was really whether an application could query against both the primary...

Thanks for the response. So let's say you had two disk luns of 10GB each. If an index is created which requires 1GB of disk space, the proportional...

Thanks for all the input, I have a lot to digest. Our "DBA manager" just told me he didn't want me involved in backups at all. At the...

Would DFS replication actually work where the data resides on our primary Netapp filer and would be replicated to a DR ( mirror ) Netapp filer? Yes we are...

Well most of our dev servers have a full copy of the production database, all 2 TB of it -- poor practice I know but it is what it is...

That makes it sound like DEV database IO would be affecting prod database IO

Well I'm disappointed to see discussions here become cat fights. Anyway, I think there are reasons both developers and DBAs exist. At our company, security auditors are looking...

Well I'm trying to get enough information about the best approach to backups, restores and disaster recovery without having to take $10,000 in courses to make the decision. Also...

What exactly did you mean by

"Having said all that, I'll echo Jeffrey - SnapManager's great for on-site backup/restore. Off-site DR, not so much. ". ?

The trick Brian, is making sure databases, tables, fields, indexes,relationships and queries scale. ORM technology is probably here to stay, but just because something works on a developer's...

My impression was that backups done via Netapp's snap manager for sql could be done very often, very fast and that for databases in full recovery, its an either or...