Where's Red Gate Press?

I've got several of their books on my desktop and not just because I work/write for them.

Wonderfully excellent advice already posted here. I'll add one more. Check out Jason Strate's Monthly DBA Checklist[/url]. It's a pretty good starting point for ensuring you have the basics in...

As much as possible, always go to the documentation in Books Online first.

Here are the requirements for Memory Optimized Tables. It's 64 bit and Enterprise only (or Development, yes).

As...

Go into SQL Server Management Studio and change the security settings for that login so that it can't access the other database. Here's an introduction to security in SQL Server.

I'd suggest taking a look at sys.dm_exec_requests to see what the process is waiting on. You'll at least understand where the bottleneck lies.

How big are those tables? Tables that are less than a single extent in size won't defrag at all. Tables that are smallish, say 2-3 extents, may not defrag fully....

I prefer backup and restore where I can do it (primary limitation would be disk space) because you don't ever risk the fundamental data files. Detach and attach, you take...

Absolutely.

On both points, using...

I very seldom use the built-in roles. I always build the roles custom. but, I only build them as needed. Not all roles are ever needed on all databases. And,...

Not seeing the maintenance plan or your structure, I'm not sure. But, something is wrong. That name is not there. It's the wrong schema, it's been renamed while you were...

Ah, infinite loop. Yeah, that'll keep executing.

Missing a commit statement? You used dirty reads (read uncommitted)? Something along these lines could easily explain it.

If you have enforced referential integrity between the two tables, you won't have to check, SQL Server will do that for you. If that value does not exist, you will...

But you can have a primary key and then a number of different unique constraints. Just because there is more than one possible candidate key in the table doesn't limit...

Seems reasonably clear. This error: Cannot find the object "dbo.TentFlowDetail_33_3439843"

It can't find the object to rebuild it. You are either passing in the wrong object name, or the wrong...