Forum Replies Created

Viewing 15 posts - 271 through 285 (of 984 total)

  • RE: Parent-Child records

    You say the key_txt field is a varchar(124), and yet the parent/child key thing expands by 16 characters each time...  16 isn't an integer multiple of 124...

    Having said...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 14, 2017 at 7:46 am

    #1946759

  • RE: Application Slow on Test Instance

    Hang on.  You've got your test environment on the same hardware as your production environment?

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 14, 2017 at 4:23 am

    #1946700

  • RE: Where to put the Group By clause?

    mitchellk.williams - Tuesday, June 13, 2017 4:39 PM

    I want to group the units by tenants, but when I put Group By tenant.scode...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 14, 2017 at 2:37 am

    #1946694

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Thursday, June 8, 2017 9:43 AM

    Brandie Tarvin - Thursday, June 8,...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 8, 2017 at 9:59 am

    #1946030

  • RE: Refreshing Table Data while other transactions quering it

    Phil Parkin - Thursday, June 8, 2017 9:20 AM

    mlueke - Thursday, June 8, 2017 9:09 AM

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 8, 2017 at 9:32 am

    #1946022

  • RE: Translate from SQL data to EDI

    Oh, man.  I've just noticed this is a SQL7/2000 thread.  I feel...dirty.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 8, 2017 at 4:35 am

    #1945966

  • RE: Translate from SQL data to EDI

    streamlinedconsulting - Wednesday, June 7, 2017 1:56 PM

    Why not just use a Software Program that's already out there, like ProEDI for the...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 8, 2017 at 4:34 am

    #1945965

  • RE: Database in Recovery Pending State

    nadersam - Wednesday, June 7, 2017 4:31 AM

    GilaMonster - Monday, June 8, 2009 5:43 AM

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 7, 2017 at 5:02 am

    #1945767

  • RE: Are the posted questions getting worse?

    rodjkidd - Thursday, June 1, 2017 6:11 AM

    I've managed to make it through the random draw for a ticket for tonight's recording...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 2, 2017 at 2:21 am

    #1945028

  • RE: Unable to start the SQL Server Agent

    A couple of thoughts...

    1. When you changed the Service account that the SQL Agent service uses, did you do this through the SQL Server Configuration Manager, or through...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    June 1, 2017 at 6:14 am

    #1944878

  • RE: group data by date range

    What about those records where startdate is after enddate?

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    May 26, 2017 at 4:27 am

    #1944302

  • RE: RAM Required to run SQL Server + Web Application + SSIS packages

    What's the storage subsystem like?  Where are the database files themselves?

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    May 23, 2017 at 2:00 am

    #1943715

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, May 18, 2017 4:25 AM

    jonathan.crawford - Wednesday, May 17, 2017 9:09 PM

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    May 18, 2017 at 4:43 am

    #1943064

  • RE: Delete nologging

    If you want to improve your performance on this sort of query, then there are a few options:

    (1) Are you deleting all the data from the table?  If...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    May 18, 2017 at 3:12 am

    #1943052

  • RE: Today's Random Word!

    RandomEvent - Monday, May 15, 2017 6:09 AM

    Ed Wagner - Monday, May 15, 2017 5:44 AM

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

    May 15, 2017 at 6:12 am

    #1942517

Viewing 15 posts - 271 through 285 (of 984 total)