What is PreSalary? Where do you want to get this from? And NetSalary?

At a minimum...

0. If your an ITIL shop, make sure Request for Change process is completed.

1. Server backup - file system, OS, etc

2. DB backup - all databases including system...

Can you post the code for the trace script. Did you use profiler to create the trace script or do it manually?

-

Jason

I would suggest Group Policy.

Except for the Oracle....

lol.

I think you can if you have Developer Edition.

here is a good article that will help:

http://dbalink.wordpress.com/2008/11/09/how-to-finding-index-usage-stats-with-dmv-in-tsql/

use SQLCMD.EXE

I love that first link! lmgtfy is now my homepage.

After you truncate the extra table, leave the file as it is. Why shrink it? The next time you build, it will have to reallocate space and grow....

I stand corrected everyone. Sorry about the incorrect information. I was told in a class that it had to be cleaned up, and never really tested it. ...

If somehow you could change the query in the app, you could use a table-valued function and pass the username as a parameter and have the function return only the...

Great article. I have been using this technique for a few months now and it saves tons of resources on the server, plus helps with my sleep when I...