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

You're basically running into limitations of the generic nature of Maintenance Plans. If they work for you, great. If they don't, the only real recourse you have is to start...

Yeah, the text is part of the issue and forced parameterization could help some. But it's use is pretty limited. Again, I'd turn it on to see if it can...

Plus the fact that no unique constraints radically changes the optimizers choices for retrieving data. I'll bet you see a LOT more scans than you should since the optimizer has...

Three suggestions.

Most of what you're going for from that basic list are either system variables (@@servername, @@version, etc.) or can be accessed from the sp_configure query. So yeah, getting that...

This introduces the concept of the a partial backup. As everyone has already stated, you can only do this if you design the database and it's structure to support the...