Forum Replies Created

Viewing 15 posts - 91 through 105 (of 906 total)

  • RE: DB Standards Reality Check

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

  • RE: DB Standards Reality Check

    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...

  • RE: T-SQL, View or Stored Procedure

    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. 

  • RE: T-SQL, View or Stored Procedure

    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...

  • RE: T-SQL, View or Stored Procedure

    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...

  • RE: Controlling Developers and Application

    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...

  • RE: Fixing the memory for SQL Server

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

  • RE: Fixing the memory for SQL Server

    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...

  • RE: Fixing the memory for SQL Server

    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...

  • RE: Finding long running SQL Agent Jobs

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

  • RE: Finding long running SQL Agent Jobs

    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...

  • RE: INSERT INTO EXEC eating ERROR in SQL Server 2000

    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...

  • RE: Date Format

    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...

  • RE: Fetch Server Name into DTS Package

    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...

  • RE: %COMPUTERNAME% does not work

    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...

Viewing 15 posts - 91 through 105 (of 906 total)