rockmoose - Thank you for you reply.  This is definitely valuable input. 

Thank you for the input.  Your point is a good one.  Truly multiple people need to be involved in developing a standard.  Clearly it shouldn't be the DBA and/or the DA that develop...

Thank you for all the replies.  I guess I got what I expected.  Speed of view verses sp procedure depends on a number of factors. 

Good point on passing parms to SP's.  What I'm really trying to find out is will a view that does a SELECT, out perform a SP that does the same...

I'm with you on the straight SELECT Statement. 

But isn't a view just a little more flexible.  You can use a view in a FROM clause very easy, whereas that...

Thanks for the replies. I hate this situation too!  I don't mind the temporary table thing so much, where we can delete these tables periodically. But I'm guessing they may not go...

RandyB - Which specify performance objects and counters where you monitoring?

Markus, I was wondering if you might elaborate on what kinds of applications seem to run better with the memory capped, as well as classify what types of application are...

Thank you for the link.  This link suggests to not fix the SQL Server memory.  Also looks like you are recommending not to fix it.  Anyone know of other links...

Please explain more.  I'm not quite sure how you get from sp_who to determining how long a job is running.

I've looked at all the MSDB tables, and don't seem to see any table that tracks running jobs.  Of course there is a sysjobhistory table but information does not appear...

Steve - Thank you for confirming that you get similar results. 

If anyone is interested I did code around this problem by capturing the return code for the XP.  Here...

Try something like:

select replace(convert(char(10),getdate(),120),'-','')

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http://www.sqlservercentral.com/bestof/

Need SQL Server Examples check out my website at...

If you go with the global variable you can set it when using the DTSRUN option /A. This might allow you to use the package on multiple servers without...

Seems to me that the implementation of supporting environment variable replacement with its value should be consistant under both MSSQLSERVER and SQLSERVERAGENT. Once again Microsoft only provide a solution...