Post reply

Date-based table purge

  • November 20, 2014 at 4:12 pm

    #298832

    Comments posted to this topic are about the item Date-based table purge

  • December 16, 2014 at 4:46 am

    #1764890

    Thanks for sharing your procedure - very interesting.

    One comment I have is that I noticed the parameters for the TableOwner (schema), and TableName are defined as varchar(64). Have you considered using the sysname type for these? This would be equivalent to a non-nullable nvarchar(128) type parameter.

  • December 16, 2014 at 5:18 am

    #1764904

    Hi, thank you for the comment.

    I'm primarily an Oracle DBA so, there are kind of things like that I don't know. It's a good idea. I'll update it in a moment.

    By the way, if you are really interested, you could go and check what I've done of this with dbWarden history purge : I've made a view from which a SQL Job reads its informations to execute.

    The view could be transformed to a table ...

    Edit : Done 🙂

  • September 8, 2016 at 6:40 am

    #1899782

    Thanks for the nice code.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply