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...

There are built in utilities that let you monitor drive space on the system. Here's an example[/url] on how to use it.

You're best bet would be to contact Microsoft directly to find out what licenses the company you purchased has through them. There's nothing stored within a SQL Server installation that...

Ed Wagner (12/2/2013)

I'm glad you did the strikeout with English and...

When you run a full backup, it also backs up the transaction log. If your transaction log has 30gb of transactions that have not been backed up (guessing based on...

You can just script out the creation of the counters and then run the script on the other server. You can save the counters you have as a template (I'm...