Forum Replies Created

Viewing 15 posts - 5,881 through 5,895 (of 8,753 total)

  • RE: SQL excessive paging

    Quick questions, what is the max memory settings for the sql server, what other services are running on the server (turn off anything not needed!)?, are you using RDP (kill...

  • RE: Snapshot of data, compare previous day

    Eric M Russell (3/31/2015)


    What I was referring to is something like the following. Here we have a subquery (X) which contains a CROSS JOIN of ID and InjectedDate, meaning is...

  • RE: Correlated query to INNER JOIN or Window function

    sql-lover (3/31/2015)


    I'm having some performance issues with a TSQL query. It's a complex statement but the main issue is the correlated query.

    Post the full query, the table structure (DDL), consumable...

  • RE: Today's Random Word!

    Ed Wagner (3/31/2015)


    Eirikur Eiriksson (3/31/2015)


    crookj (3/31/2015)


    whereisSQL? (3/31/2015)


    Eirikur Eiriksson (3/31/2015)


    Ed Wagner (3/31/2015)


    Revenant (3/31/2015)


    Ed Wagner (3/31/2015)


    djj (3/31/2015)


    Ed Wagner (3/31/2015)


    crookj (3/31/2015)


    Ed Wagner (3/31/2015)


    TomThomson (3/31/2015)


    Eirikur Eiriksson (3/30/2015)


    SQLRNNR (3/30/2015)


    lingus

    Port

    Wine

    Cheese

    Mouse

    Cat

    Lion

    Tiger

    Mom

    Cub

    Hive

    Bee

    Line

    Knot

    Tied

    Down

  • RE: Today's Random Word!

    crookj (3/31/2015)


    whereisSQL? (3/31/2015)


    Eirikur Eiriksson (3/31/2015)


    Ed Wagner (3/31/2015)


    Revenant (3/31/2015)


    Ed Wagner (3/31/2015)


    djj (3/31/2015)


    Ed Wagner (3/31/2015)


    crookj (3/31/2015)


    Ed Wagner (3/31/2015)


    TomThomson (3/31/2015)


    Eirikur Eiriksson (3/30/2015)


    SQLRNNR (3/30/2015)


    lingus

    Port

    Wine

    Cheese

    Mouse

    Cat

    Lion

    Tiger

    Mom

    Cub

    Hive

    Bee

    Line

    Knot

  • RE: T-SQL Help...probably pretty simple but I'm tired :)

    ScottPletcher (3/31/2015)


    As a side note, but still critical, let me warn everyone to use lowercase only for data type names in SQL Server. That is, "int" not "INT", "datetime"...

  • RE: Today's Random Word!

    Ed Wagner (3/31/2015)


    Revenant (3/31/2015)


    Ed Wagner (3/31/2015)


    djj (3/31/2015)


    Ed Wagner (3/31/2015)


    crookj (3/31/2015)


    Ed Wagner (3/31/2015)


    TomThomson (3/31/2015)


    Eirikur Eiriksson (3/30/2015)


    SQLRNNR (3/30/2015)


    lingus

    Port

    Wine

    Cheese

    Mouse

    Cat

    Lion

    Tiger

    Mom

    Cub

    Hive

  • RE: How to optimize this query

    Quick question, can you provide the table structures (DDL), some sample data and the actual execution plan?

    😎

  • RE: Not able to install SQL 2005 on Windows 7 (SQL server 2008 is already installed)

    Quick question if I may, why installing SQL Server 2005?

    😎

  • RE: Undetached databases cannot be attached

    nick 51459 (3/31/2015)


    Thanks but no joy.

    When I open the Attach Database dialogue box to locate a database, no files appear in the window.

    This tells me that the permissions have not...

  • RE: Undetached databases cannot be attached

    Quick thought, check the file/folder permissions and make certain thar the Sql Service can access the files.

    😎

  • RE: Snapshot of data, compare previous day

    SQL_Kills (3/29/2015)


    A0001 still needs to appear as 50 as a Difference for the InjectedDate 2015-03-05 23:19:01.727

    Quick question, do you mean that you want to add missing entries as zero value,...

  • RE: Today's Random Word!

    SQLRNNR (3/30/2015)


    lingus

    Port

  • RE: Today's Random Word!

    SQLRNNR (3/30/2015)


    snake

    Oil

  • RE: does the databases actually update

    swchoi.choi (3/30/2015)


    I have been told that when you run a sql statement on a database, it doesn't actually update the table. It's committed to a log. Is this true ?

    Think...

Viewing 15 posts - 5,881 through 5,895 (of 8,753 total)