typically you'd want to check for useful indexes , usually distinct implies duplicates, normalisation might help.

I'm not sure I quite understand what you're doing but clustering is purely for availability , not for performance.

Largely the capacity for transactions is limited by the i/o capacity of...

there are a number of tables in msdb which do not clear down, most dba's write routines to delete the data from a certain date. Deleting data always has an...

or you could use a computed column

update table set newcolumn = left(oldcolumn,2)

They can all be moved and are covered in technet, it takes a bit of stopping and starting of services. I think this is the kb number KB224071

afaik you need the t SQL events.

sorry, just thought it may be the table has to span an extent to be reported correctly?

could well have done, if I get time I'll run some checks - I generally exclude small tables from reindexing.

I'd recommend the training courses that make up the mcdba.

The ms pocket admin is avaialble on-line

http://msdn.microsoft.com/library/?url=/library/en-us/startsql/portal_7ap1.asp?frame=true

you might be suffering with active transactions, there's something I recollect about things not finishing correctly and thus leaving a pointer/entry in the log beneath which the system won't truncate....

The other issue you might have is that updated stats/index rebuilds will mark the proc for recompilation, if you have auto stats turned on this could happen at almost any...

usually the user has a smtp email address identical to their domain login - you can use this with the domain to create a mail address. You can run a...

use QA or job to shrink the datafile, EM doesn't do the job

use

dbcc shrinkfile(fileid)

It's brutal but this will reclaim the max space. Issue a checkpoint command first.

If the plan is getting aged out then the proc will not be getting called very often - the whole point of the process is to only keep oft used...