true.

Thank you Rookie,

The choice I have is --> RAID5 storage for data. There is no way I can separate tables (or database) to by disk (controllers). Everything is going to...

can you please explain why?

Regards,

Monitor the query plan.

Even thou the stored procedure is encrypted you may look at its execution (query) plan and find problematic operations.

Hello Dan,

You may try to run the SQL Profiler to monitor "Login Audit Failure" events. http://www.sqlservercentral.com/columnists/bkelley/auditingwithsqlprofiler.asp

I am not sure whether it will display proper IP or Host Name...

Hello,

you may want to read about format files. The bcp or BULK INSERT allow to use so called "format files", where you may specify that delimiter between fields is...

step 1. clear the transaction log from any transactions

backup log tempdb with truncate_only

step2. make sure the file is empty (size=0), so that you can call ALTER DATABASE

dbcc shrinkfile (TempLog_FileNo2, EMPTYFILE

step3

alter...