Forum Replies Created

Viewing 15 posts - 211 through 225 (of 984 total)

  • RE: Send email when a field is 0

    hoseam - Monday, October 30, 2017 11:39 PM

    Phil Parkin - Monday, October 30, 2017 2:01 PM

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

    October 31, 2017 at 4:43 am

    #1965926

  • RE: Duplicate data

    Eirikur Eiriksson - Tuesday, October 31, 2017 2:14 AM

    joekanant 53667 - Tuesday, October 31, 2017 1:51 AM

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

    October 31, 2017 at 4:37 am

    #1965924

  • RE: PURGING DATA

    Can you provide some small sample data showing what you expect to happen to each row?

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

    October 27, 2017 at 4:54 am

    #1965474

  • RE: SQL Server Query is taking high CPU

    Can you provide the execution plan for this query?

    Also, what indexes exist on the tables used?

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

    October 27, 2017 at 4:42 am

    #1965472

  • RE: Where query time between 6am and 6pm

    spyfly - Thursday, October 26, 2017 9:26 AM

    ThomasRushton - Thursday, October 26, 2017 8:02 AM

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

    October 26, 2017 at 9:34 am

    #1965344

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor - Thursday, October 26, 2017 8:02 AM

    jasona.work - Thursday, October 26, 2017...

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

    October 26, 2017 at 8:05 am

    #1965305

  • RE: Where query time between 6am and 6pm

    I thought you were looking for records where the hour was between 06:00 & 18:00, but your query says between 08:00 & 14:00...

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

    October 26, 2017 at 8:02 am

    #1965304

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Saturday, October 21, 2017 2:06 PM

    Still here I see.

    Where else would we be?

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

    October 22, 2017 at 10:02 am

    #1964704

  • RE: Timestamp test.

    Computerphile - Time Zones.  https://www.youtube.com/watch?v=-5wpm-gesOY

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

    October 20, 2017 at 8:25 am

    #1964492

  • RE: Table Index

    GDPR compliance?  mm'kay.

    I would have thought it might be handy to have a few other GDPR-related flags in there, as there are some "features" of GDPR that can...

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

    October 19, 2017 at 9:45 am

    #1964369

  • RE: Data row does not have a matching index row in the index

    Check your error logs.  Do you see any error messages, specifically, any of errors 823, 824, 825, 829?

    If so, then you'll need to get your storage team involved.

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

    October 18, 2017 at 7:20 am

    #1964202

  • RE: Are the posted questions getting worse?

    Jack Corbett - Tuesday, October 17, 2017 6:37 AM

    Jo Pattyn - Tuesday, October 17, 2017...

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

    October 17, 2017 at 6:57 am

    #1964003

  • RE: Where query time between 6am and 6pm

    What I would do is firstly change your Start/EndDate calculations to form a bit simpler to understand:

    SET @EndDate = DATEADD(MONTH,DATEDIFF(MONTH,'20100101',GETDATE()),'20100101'); -- first of this month
    SET...

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

    October 16, 2017 at 6:40 am

    #1963802

  • RE: Transaction log grows. Strangely problem

    dmbsseller - Friday, October 13, 2017 4:47 AM

    Guys, thank you
    Actually, 80 % I'm sure that I found the reason for the...

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

    October 13, 2017 at 5:26 am

    #1963530

  • RE: Are the posted questions getting worse?

    Thom A - Friday, October 13, 2017 4:42 AM

    ThomasRushton - Friday, October 13, 2017 2:27 AM

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

    October 13, 2017 at 5:22 am

    #1963528

Viewing 15 posts - 211 through 225 (of 984 total)