SQL Server does cache data in memory. If you use SET STATISTICS IO ON and view the results logical reads are reads from memory while physical reads are when...

If you set the hidden property to true then they will be collapsed by default.

If you are using SSIS you do not need to export to a CSV. You can directly access the FoxPro table(s). You can download the FoxPro OLEDB driver...

Can you post the code that is working and the code that is not working?

If the person is using SSMS to connect to the server there is no way to keep them from seeing databases that exist (at least not that I know of)...

You can also visit Ola Hallengren's site[/url] he has a set of database maintenance scripts that include backups.

If you install the client tools for SQL Server 2005 then Business Intelligence Development Studio (BIDS), a slimmed down version of Visual Studio, that allows you to develop reports...

Well, if you have autocreate statistics on, I'm going to guess that SQL Server will end up creating most of the statistics recommended by DTA.

In my opinion, indexing is more...

Well, your query could specify SELECT DISTINCT or a GROUP BY to eliminate duplicates. Also in report you can choose to only show a value once.

What events are you tracing in the trace?

Here's an article[/url] that applies to your situation.

Actually if you use a server-side trace with only the sql:stmtcompleted event filtering on TextData you probably wouldn't even realize the trace is running. Are you aware that with...

When you convert a date to varchar it is doing character conversion which is different than data conversion. You would need to be sure that the date strings are...

No problem, as long as what you have works.

I'd do as Flo has recommended although with the caveat that you may want to look at executions in addition to duration. You may get a bigger boost out...