izdede (5/4/2010)

---

Thanks for all your help but as I thought, which is why I chose to post here, the solution seems to be a moving target.

Both my machine and the...

The problem is you can't count on the estimated costs within execution plans to make a determination whether or not they're performing well because those costs are based on an...

I'm with Gianluca, again. If you created the proc without a schema owner, it may have been created under your login. If you then try to execute it without including...

If you bring in a third party tool like Hyperbac, you can access individual tables for restore of data from a database, file, or filegroup backup. Other than that, I...

Sounds like you're reading Itzik Ben-Gan's book. Excellent resource.

Derived tables are not the same thing as tables. A derived table is a way to use a query construct, such as...

Yeah, Red Gate's SQL Refactor can do that type of work for you. You would still want to test, test, test, to be sure it got things right.

The whole idea of relational data storage is that there is something to relate one entity to another. No relation, no join. Something makes you think that there is a...

I agree with Dave, specifics on your system are hard to say without a lot more detail. However, I would be very careful about indexes 2 & 3 in that...

Try RESTORE FILELISTONLY. I think that'll get you what you want.

Whoa! A covering index is not a index that includes every column in the table. That's wrong.

A covering index is an index that provides all the columns needed by a...

Why is archiving taking so long? Are you trying to move everything or is it that the queries themselves are taking so long? If the queries are running slow because...

Just remember that you'll need to sweat contention for resources, i/o, cpu, memory, tempdb, all are part & parcel of creating indexes, so testing in a completely isolated environment will...

I don't see any reason why the commit would not fire. Maybe using TRY/CATCH instead of the old style error handling will allow you to control the flow better. It...

Agreed. That's not really an issue.

Check the login that the scheduling service is running under. Check the owner of the job that is being run and check the security settings on the script itself. It's...