Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,838 total)

  • RE: Refreshing parameter values

    OK, that shouldn't matter, looking at it further, on my report it looks like it only updates the dependent parameters the first time, it may be related to this bug...

  • RE: User_update high but no user seek/scan. Is this an effective index?

    the main problem with using data from sys.dm_db_index_usage_stats directly is that the data there gets reset when the service restarts..  Do you know the uptime of this server?
    [code...

  • RE: How to obtain first, but not empty value?

    how about something like this?
    WITH invoice_sums AS
    (SELECT invoice_number, passenger_name,
        SUM(fare) OVER (PARTITION BY invoice_number) AS total_fare,
        SUM(commission) OVER (PARTITION BY invoice_number) AS total_commission,
       ...

  • RE: Refreshing parameter values

    how do you have the StartDate and EndDate parameters setup?  I've seen something similar, where the StartDate and EndDate parameters have properties of:
    Default Values: Specify Value, using a Switch...

  • RE: Are too many linked servers possible?

    I think the problem with linked servers isn't in how many you have setup, but the performance each time you use one.  I've seen systems where the performance limitation was...

  • RE: Short Names

    chrisn-585491 - Monday, July 17, 2017 12:32 PM

    That's why we  use YYYY_MM with the MM being the number of the month. So...

  • RE: Same query different Execution plan on two different server

    OK, if CPU, memory, disks setup the same, have you checked the "cost threshold for parallelism" and "max degree of processing" on the 2 servers?

    More importantly, looking deeper...

  • RE: Short Names

    Sinisa Jazic - Monday, July 17, 2017 9:42 AM

    If I could talk to an OS (HAL 9000) then I would refer to...

  • RE: Same query different Execution plan on two different server

    I notice on Server1 the execution plan went parallel in multiple places, does Server1 have more CPU cores in it than Server2?  That could be a contributing factor in it...

  • RE: Comparing values from calculated fields

    my favorite way to do this is to use CROSS APPLY to unpivot the data and then just use MAX():
    DECLARE @yourtable TABLE
    (colA INT,
    colB INT,
    colC...

  • RE: Short Names

    djackson 22568 - Monday, July 17, 2017 7:27 AM

    The FIRT THING every intelligent person I know does, when building a new PC,...

  • RE: Are the posted questions getting worse?

    Thom A - Thursday, July 13, 2017 7:59 AM

    does anyone know where you find SQL Server 2012 Developer?

    I don't think developer...

  • RE: Drop specific table

    newdba2017 - Wednesday, July 12, 2017 3:01 PM

    what about setting up a proxy account so the user can execute the Stored procedure...

  • RE: Inner/Outer Join

    Are you sure that tblB.id is the proper foreign key column to join bacl to tblA.id with?  If you join on the wrong column then yes the results for tblB...

  • RE: Correspond Row Data

    Well I didn't really gain this level of knowledge just from books, it's more a mix of techniques from various resources and years of doing some trial and error experimentation...

Viewing 15 posts - 856 through 870 (of 1,838 total)