Forum Replies Created

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

  • RE: SQL Server 2000 Data Loss

    Few more questions (bear with me), When was it moved to ESXi 5.5.0? Windows OS version? Recent upgrades/updates? Which drivers does VB use? Was this originally on SQL 7.0?

    😎

    April 1, 2015 at 12:30 pm

    #1788112

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

    dwain.c (3/31/2015)

    CELKO (3/31/2015)

    Abend? Jeez, now there's a word I haven't heard since I was using IBM 360 JCL!

    LOL! Remember the quote: "OS/JCL makes sense after you have studied...

    April 1, 2015 at 11:58 am

    #1788104

  • RE: SQL Server 2000 Data Loss

    Quick questions, have you checked all log files? Are only updates failing while other activities (insert / delete) are working?

    😎

    Had a similar issue way back, turned out to be a...

    April 1, 2015 at 11:07 am

    #1788089

  • RE: SQL excessive paging

    Abhijit More (4/1/2015)

    Eirikur Eiriksson (4/1/2015)

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

    April 1, 2015 at 9:14 am

    #1788053

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/1/2015)

    Who remembered to do an April Fools post today?

    Being modest this year, I only posted one question😀

    😎

    April 1, 2015 at 9:06 am

    #1788044

  • RE: Correlated query to INNER JOIN or Window function

    You can use the free version of SQL Sentry Plan Explorer to obfuscate it.

    😎

    April 1, 2015 at 9:01 am

    #1788040

  • RE: Today's Random Word!

    djj (4/1/2015)

    crookj (4/1/2015)

    Ed Wagner (4/1/2015)

    crookj (3/31/2015)

    Eirikur Eiriksson (3/31/2015)

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

    April 1, 2015 at 7:23 am

    #1788007

  • RE: How to optimize this query

    Quick suggestion, add a clustered index to those heaps and look into indexing them, the table scans are more than 80% of the cost.

    😎

    April 1, 2015 at 7:21 am

    #1788005

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

    April 1, 2015 at 5:35 am

    #1787965

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

    March 31, 2015 at 8:43 pm

    #1787903

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

    March 31, 2015 at 7:29 pm

    #1787899

  • 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

    March 31, 2015 at 12:38 pm

    #1787836

  • 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

    March 31, 2015 at 12:28 pm

    #1787831

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

    March 31, 2015 at 12:27 pm

    #1787830

  • 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

    March 31, 2015 at 12:22 pm

    #1787826

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