I would check the memory usage on the server.  If this is a long running application then it will be fighting for memory from the same hardware as SQL and...

Have you tried using an ORDER BY Year, Month in your SELECT?  Don't know if this is possible with dimensions but thought I would throw it ....

IF you know how large all of your databases are (and what drives they are on) along with the logs + drive freespace would that not be close enough??

1.  CAST(Field AS SMALLINT)

2. CONVERT(SMALLINT, Field)

3.  Chop it up into small little bites, season liberally and bake at 350 F for 15 minutes.  Taste good with a red wine

What are the multiple SELECTs doing?  IF they are populating variables research SET @var = (SELECT ...)

ISNULL(val, '00') ???

please see messages posted to http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=152973

Probably because both of these systems are NT based and can see the same locations as each other.  I am assuming that the drive the SQL was installed on is...

One way:  Bring all the records into a "staging" area and then apply the business rules from there...

DROP = throwing the bucket away.

ERASE/DELETE/TRUNCATE = emptying the water in the bucket

Not to my knowledge unless you have history tables with that information...

Better mousetrap.  Create an NT group (Windows or Active Directory).  Assign ALL users that can get to the system to that group.

This way you already know the group and can...

Try instead of " use '  this is proper syntax for doing this 'something' + ' ' + ..

Kenneth is absolutely correct.  The system tables are updated for any given object ONLY when that object is installed/re-installed.  I found out that one of our System Analysts has been...

Ok, so from the GUI you want them to be able to see current job status.  And having them check sp_who2 is not an option..

Sounds like you have unrealistic requirements... ...