As per the question concerning running a script from a folder or needing to create a new script. That depends - both are viable options.

Hmmm - depends. Production might just be his desktop

I'll take that risk. See where it goes.

To get results from a table, you do this:

Select * from yourtablename

It sounds like you did this:

create table yourtablename (col1 varchar,col2 varchar)

Or something to that effect.

Alvin Ramard (1/22/2010)

CirquedeSQLeil (1/22/2010)

Kit G (1/22/2010)

P Jones (1/22/2010)

Then there is one application that uses MSDE... and they have it locked down so that we can't even access it to do...

Illuminati

Nice list - thanks

Kit G (1/22/2010)

P Jones (1/22/2010)

Bet that's...

In addition to query tuning, and Index maintenance - I suggest proper indexing.

Another expensive option is to replace your disks with solid state disks or flash drives - very very...

What was microsoft thinking on this one?:-D

Lynn Pettis (1/22/2010)

Can't...

I would go so far as to increase the tlog backup interval to every 5 minutes during index rebuilds / reorgs

praetorians

Keep in mind that you will have to query while the tempdb is growing.

It was cheaper back when I was interested in attending there.

There is a cheaper alternative currently for MIT - tell her to do the Open CourseWare program

http://ocw.mit.edu/OcwWeb/web/home/home/index.htm