Forum Replies Created

Viewing 12 posts - 31 through 42 (of 42 total)

  • RE: Break down a delete statement

    Thanks for all your help.

    Susan 

  • RE: Break down a delete statement

    Thanks for your help, I tried the code above added with my insert statement, but not sure I'm declaring my table variable in the right spot. Here is the error...

  • RE: Break down a delete statement

    We don't want to process more than 100,000 rows at a time because the job runs long. We need a commit every 1000 so the table is released between deletes.

    I...

  • RE: How to multitask stored procedures?

    You can pass parameters to stored procs that are in a job. We do it all the time.

    exec Delete_Task_Result 120

    You could also create one stored proc that executes...

  • RE: sp_spaceused tablename for each database

    Two words for you Amit..

    YOU ROCK!!!

    thanks soo much for your help.

  • RE: sp_spaceused tablename for each database

    The result's I used were from amitjethva.

     

    Thanks in advance

     

     

  • RE: sp_spaceused tablename for each database

    Thanks.. that is EXACTLY what I'm looking. Now my only issue is putting the info into a table. Every time I try an insert I get an error message that...

  • RE: sp_spaceused tablename for each database

    Sorry forgot to add the script

    /*******************************************************************************

      Written By  : Simon Sabin

      Date        : 25 October 2002

      Description : Returns the spaceused by all tables in a database

                  :

      History

     ...

  • RE: Unable to modify filegrowth on TEMPDB

    I found this article in

    Microsoft Knowledge Base Article - 816939

    PRB: File Growth Value for TempDB is Not Persistent When Changed From Fixed Increments to Percentage

    I'm...

  • RE: Cache

    I thought the 'auto_statistics' 'On' option would have already updated the stats and the plan. I thought when the stats are updated automatically, the SP's would in turn be marked...

  • RE: Cache

    Right, they are revisiting the query and plan on revising it. However, I just don't understand how recompiling the SP's would fix the slow down issue. My understanding that the...

  • RE: Cache

    The proc really runs a dbcc flushprocindb

    Here's the code..

    create procedure sp_flush_db_procs

    @dbname sysname=NULL

    --

    --Flush the Procedure cache for a database.

    --

    --If no database name is supplied then flush

    --the current database.

    --

    --WARNING: This SP uses...

Viewing 12 posts - 31 through 42 (of 42 total)