Viewing 15 posts - 91 through 105 (of 906 total)
rockmoose - Thank you for you reply. This is definitely valuable input.
July 19, 2004 at 5:50 pm
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...
July 19, 2004 at 4:40 pm
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.
July 7, 2004 at 11:16 am
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...
July 6, 2004 at 2:00 pm
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...
July 6, 2004 at 12:12 pm
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...
June 29, 2004 at 11:37 am
RandyB - Which specify performance objects and counters where you monitoring?
June 3, 2004 at 9:43 am
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...
June 3, 2004 at 8:46 am
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...
June 2, 2004 at 11:14 am
Please explain more. I'm not quite sure how you get from sp_who to determining how long a job is running.
May 25, 2004 at 10:48 am
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...
May 24, 2004 at 8:17 pm
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...
February 26, 2004 at 2:27 pm
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...
December 30, 2003 at 8:58 am
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...
December 30, 2003 at 8:07 am
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...
December 30, 2003 at 8:00 am
Viewing 15 posts - 91 through 105 (of 906 total)