The best most sure fire way to get it to move properly and not lose triggers or constraints is to use EM as everything is scripted there. Looking in Profiler...

You can create a filegroup that is comprised of multiple physical files and span that way. SQL will treat overall as a single unit. This goes for any setup situation.

"Don't...

I agree with Andy, many are intrusive or run intrusive processes which will add load to your server. If you have concerns over the usage you don't want to add...

No not really, however I posted previously a way to use a temp table or table variable with a single text datatype field in it so you can use it...

Actually you do not have to specify a size on the datatype char or varchar

CONVERT(CHAR,GETDATE(),101) will work just fine.

"Don't roll your eyes at me. I will tape them in place."...

That also depends on how you have you log files setup and when the last backup may hve truncated. The best way is to use profiler to catch when a...

Then I go back and say try profiler since you know how it occurrs and see what is going on under the hood of SQL with the calls. Otherwise try...

A common missed cause, at least for SQL 7, was maintainence of indexes. If you do a rebuild of indexes then the clustered index rebuild usually double the size of...

The best way to avoid locks is to find out what sequence is causing them. What queries are the root and why. If the locks are still there when you...

You are correct here is the information from SQL 7 BOL

quote:

---

dtsrun Utility

The dtsrun utility allows you to retrieve, execute, delete, and overwrite...

Note really sure you need the subquery as you have it.

SELECT * INTO reporting_table

FROM transaction_history th1

WHERE th1.trans_date =

(SELECT MAX(th2.trans_date) FROM

transaction_history th2

WHERE th1.field1 = th2.field1 AND

th1.field2 = th2.field2 AND...

If you add TSQL:StmtStarting I believe it will show up usually 1-3 records before the table scan event.

"Don't roll your eyes at me. I will tape them in place." (Teacher...

Not sure why you want Buffer Cache hit perf alerts when you state.

quote:

---

I know I am running out of RAM and...

Depending on the size of each table it may or may not improve performance. It should not hurt performance if indexed properly. However some may say this doesn't follow the...

Or if you want to avoid the whole WITH RECOMPILE problem and the dynamic issue where query plans are not stored, then create seperate Procs for each situation then a...