I think the thread went a little sideways since the same advice was thrown out there. Get help. I can understand that is a little overwhelming. For people that don't...

I bet you have. At least some times. If you're here...

TravisDBA (7/23/2010)

---

Every manager I have ever asked about ROWE did not like it. Here is what some of them had to say about ROWE:

[\quote]

I think your managers are confusing telecommuting...

The code is good through the first day of the PASS Summit. You can always use it. The discount is $200 now, it was $100 earlier, and applies to the...

What's not clear? Are you talking to the OP or people who answered?

"Provided by me" means...

A few things.

First, as much as you might not think...

I couldn't think of another plausible real item, so I came up with SQL Traps.

Great explanation from OCTom.

I've added my vote as well and will drop it on Twitter to scrounge for votes.

I'd agree that we need more information. Table defs, some sample data, indexes. It's too hard to guess at what could be going on. Don't forget that with larger joins...

Why isn't the space enough? You need it to log the imports, regardless of whether you shrink.

Also shrinking means that you are introducing fragmentation, and undoing much of the reindexing....

I'm done with indexes and games for today. No BBQ, but I did make some gazpacho today.

I tend to agree with you, Gail, but a reference is a reference for purposes of discussion.

I do think this is a thorny issue. Would welcome debate, and a Connect...

BOL certainly isn't consistent, and we did submit a few changes for them to make the version pages more consistent.

These two are certainly at odds with the other one. However...

You can easily do this on ServerA with a command line call. Server A is a client of server B, so they can use SQLCMD -E -S "ServerB" -Q "Backup...

I added a note in the QOD as well, since I don't view BOL as "true", but as a reference.