Post reply

What's changed recently?

  • May 31, 2013 at 10:39 am

    #278432

    Comments posted to this topic are about the item What's changed recently?

  • July 1, 2013 at 6:56 am

    #1628689

    SQL 2000, at least from what I can determine would be.

    SELECT TOP 22 * FROM sysobjects ORDER BY refdate DESC

  • November 15, 2014 at 8:54 pm

    #1758819

    Thanks for this! But why select the top 22 only?

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • November 16, 2014 at 2:21 am

    #1758824

    Hi

    Typically only a small number of rows have changed recently (unless there's been a table defrag), I want a small number of rows, so 22 seems appropriate... 11 or 33 etc are also good 🙂

    Ian

  • November 19, 2014 at 2:05 pm

    #1759640

    ianstirk (11/16/2014)

    Hi

    Typically only a small number of rows have changed recently (unless there's been a table defrag), I want a small number of rows, so 22 seems appropriate... 11 or 33 etc are also good 🙂

    Ian

    Ah, OK - thanks! 🙂

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • October 20, 2015 at 2:53 am

    #1834275

    IS SQL 2012, add "where object_id > 0" to exclude temporary objects

  • October 20, 2015 at 6:29 am

    #1834335

    Short and sweet!:-)

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • October 20, 2015 at 6:41 am

    #1834338

    Object schema is sometimes good to know.

    select "Schema" = object_schema_name(so.object_id), * from sys.objects as so

    where so.modify_date > dateadd(month, -2, getdate()) and so.object_id > 0

    order by "Schema", so.modify_date desc;

  • October 21, 2015 at 6:45 am

    #1834612

    What a great little script, thanks.

Viewing 9 posts - 1 through 8 (of 8 total)

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