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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • RE: Timestamp test.

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

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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

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