Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 7,614 total)

  • RE: Slow running query

    Great, thanks!  See if something like this is a good start to what you need.
    Btw, if the call table is clustered first on StartTime (as it almost certainly should...

  • RE: Slow running query

    If you'd provide some usable sample data -- CREATE TABLE and INSERT statements -- for QueueCallItems, I (and others) can code something up.  Sorry, but I just don't have additional...

  • RE: Find out all the tables with VARBINARY column


    SELECT SCHEMA_NAME(t.schema_id) AS schema_name,
        t.name AS table_name,
        c.name AS column_name,
        c.max_length,
        c.is_nullable,
        c.is_computed
    FROM sys.columns c
    INNER...

  • RE: Question Regarding Date logic

    Sergiy - Saturday, January 27, 2018 5:21 AM

    Scott, it seems you forgot what is the controversy we're discussing.I'm saying that EOM (end...

  • RE: Question Regarding Date logic

    Sergiy - Friday, January 26, 2018 8:41 AM

    No.  You need to put some thought into the actual...

  • RE: Question Regarding Date logic

    But if only the start date is in the row, how do you handle "changes in interval"?  And especially a variable interval, say, where some rows apply for 2 weeks...

  • RE: With Schemabinding

    RonKyle - Thursday, January 25, 2018 9:15 AM

    You seem fixed to the idea that "every view must be schema bound." That's...

  • RE: With Schemabinding

    You seem fixed to the idea that "every view must be schema bound." That's just not true, and probably not even optimal.

  • RE: Question Regarding Date logic

    Sergiy - Thursday, January 25, 2018 8:28 AM

    Below86The only thing I can say is that low scale of the project is no...

  • RE: With Schemabinding

    I simply offered an alternative: rather than searching for errors yourself, let SQL find them for using sp_refreshview. Probably on your qa/test system,  as the views are likely identical or...

  • RE: With Schemabinding

    pdanes - Thursday, January 25, 2018 7:17 AM

    ScottPletcher - Thursday, January 25, 2018 6:56 AM

  • RE: Question Regarding Date logic

    Sergiy - Wednesday, January 24, 2018 8:28 PM

    Say we have your table with only beginning dates. Now I want to join to...

  • RE: With Schemabinding

    pdanes - Wednesday, January 24, 2018 5:15 PM

    ScottPletcher - Wednesday, January 24, 2018 12:46 PM

  • RE: Question Regarding Date logic

    Sergiy - Wednesday, January 24, 2018 3:11 PM

    Sometimes when joining, it's easier if the ending value is in the row itself. It's...

  • RE: With Schemabinding

    pdanes - Wednesday, January 24, 2018 12:03 PM

    ScottPletcher - Wednesday, January 24, 2018 7:10 AM

Viewing 15 posts - 3,571 through 3,585 (of 7,614 total)