You can run SSDT (based on VS 2010) on a 32-bit machine but it requires Vista or newer.

Chances are the sporadic part arises because the request usually finishes in under 30 seconds (the default CommandTimeout) but if things are busy or otherwise delayed and the database call...

I have used this feature in other MS apps but never noticed it in SSMS. Now that I can take notice of the feature I will certainly use it. Who...

I would probably bounce the instance but I can understand you not wanting to impact the other databases on the instance. If you have success with changing the 'enabled' flag...

It is configurable. Run sp_help_log_shipping_primary_database against master on your primary instance and look for the backup_compression column

Are you sure that is the entire output? I see you are appending -S but it is not in the comment where you say "output looks like this"

bcp "exec RSDV_App..Rpt_JobTransactionsSp...

If I am right...

IMHO the information in sys.dm_io_virtual_file_stats is a bit low-level for management's taste. If you're trying to communicate how busy your server is, maybe for an executive overview or something like...

Sounds good to me. Thanks for posting back the results.

Now might be a good time to double-check on your auto-grow settings too. I like to use MB instead of...

You could try using SSIS to do the conversion for you on the fly. Use an OLE DB Source in a Data Flow to get the data from the database...

sqlstar2011 (3/19/2013)

---

so how can I best interpret this? what does number of read mean? chunks of data in bytes? how big of chunk if that's the case.

how can I...

You mean other than the query executing and the retrival of data occurring? What is the root of your question? Can you be more specific?

No worries. We'll get...

OK, SQL Agent data, that's good, the use case fits, but you're repurposing it so how much data are we talking about? For managing SQL Agent historical data the scalar-function...

Cores, or threads? What exactly are you seeing that is making you think it is...