Forum Replies Created

Viewing 15 posts - 211 through 225 (of 1,228 total)

  • RE: Reseed Max value

    If you change your identity column to BIGINT, you won't have to deal with duplicate ID's. The point of an identity column is to uniquely identify each row, with the...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 7, 2014 at 2:41 am

    #1695018

  • RE: Query of 100 mil rows with multiple parameters

    GilaMonster (3/4/2014)

    ChrisM@home (3/4/2014)

    1. How often do you change a clustered index on a production db?

    I do fairly often, but then that's what I do mostly (database tuning on various badly...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 4, 2014 at 12:59 pm

    #1694053

  • RE: Query of 100 mil rows with multiple parameters

    Jeff Moden (3/4/2014)

    ChrisM@home (3/4/2014)

    Jeff Moden (3/2/2014)

    I guess my first recommendation would be to make the PK a nonclustered index. It's currently way too wide to be of any practical...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 4, 2014 at 12:49 pm

    #1694046

  • RE: Query of 100 mil rows with multiple parameters

    Jeff Moden (3/2/2014)

    I guess my first recommendation would be to make the PK a nonclustered index. It's currently way too wide to be of any practical use as a...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 4, 2014 at 11:11 am

    #1693999

  • RE: Query of 100 mil rows with multiple parameters

    GilaMonster (3/4/2014)

    ChrisM@Work (2/28/2014)

    Secondly, your ordinary index has most of the columns of the clustered index as INCLUDE columns. This is unnecessary because nonclustered indexes contain the cluster keys - they're...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 4, 2014 at 11:08 am

    #1693996

  • RE: How to update a Table using Loop?

    eligiable (3/2/2014)

    Hi Jeff Moden

    1st alteration will allow to store the Counter values in CounterDesc as an INT or BigINT depends on the records (I got 1 Million and increasing), so...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 2, 2014 at 2:41 pm

    #1693397

  • RE: How to update a Table using Loop?

    -- always check an update as the equivalent SELECT before running it.

    -- you may wish to replace the ORDER BY to, say, TerminalNo

    SELECT

    MerchantNo,

    TerminalNo,

    CounterNo = ROW_NUMBER() OVER(PARTITION BY MerchantNo ORDER...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 2, 2014 at 6:19 am

    #1693365

  • RE: retrieve last date for item from two tables?

    Very easily:

    SELECT

    wea = ISNULL(s.wea,c.wea),

    date_time_rt_group_status = MAX(s.date_time),

    date_time_rt_group_coverage = MAX(c.date_time)

    FROM rt_group_status s

    FULL OUTER JOIN rt_group_coverage c

    ON c.wea = s.wea

    GROUP BY ISNULL(s.wea,c.wea)

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 2, 2014 at 3:08 am

    #1693359

  • RE: Geeky Entertainment

    Larry Niven "The Magic Goes Away" has plenty of scope for humour.

    Stephen R. Donaldson "The Chronicles of Thomas Covenant" bewitched a whole generation of kids including me and deals with...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 1, 2014 at 11:11 am

    #1693333

  • RE: Geeky Entertainment

    jasona.work (2/28/2014)

    below86 (2/28/2014)

    Wonder Woman!! Linda Carter is still hot.

    :w00t::cool:

    Another book I wouldn't mind seeing made into a movie would be Fallen Angels by Niven / Pournelle / Barnes (I...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 1, 2014 at 11:02 am

    #1693332

  • RE: Geeky Entertainment

    Byron.H (2/28/2014)

    Any of the books from the "Culture" series by Iain [M] Banks, although I recall reading somewhere that the late author preferred not to have his books translated to...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 1, 2014 at 10:58 am

    #1693331

  • RE: Geeky Entertainment

    markradley (2/28/2014)

    I'd love to see a movie version of Rendezvous With Rama by Arthur C. Clarke

    I recently discovered that has been a project of Morgan Freeman's for the last decade,...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 1, 2014 at 10:53 am

    #1693330

  • RE: How to Get data from Table2 instead of Table 1?

    Impossible to "give a query" as Lynn states. You will need to post table definitions with sample data scripts to get a query.

    Try full outer joining the two tables on...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 1, 2014 at 10:49 am

    #1693329

  • RE: retrieve last date for item from two tables?

    SELECT

    wea = ISNULL(s.wea,c.wea),

    date_time = MAX(ISNULL(s.date_time, c.date_time)),

    TableSource = MAX(CASE WHEN s.wea IS NULL THEN 'rt_group_coverage' ELSE 'rt_group_status' END)

    FROM rt_group_status s

    FULL OUTER JOIN rt_group_coverage c

    ON c.wea = s.wea

    GROUP BY...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    March 1, 2014 at 10:37 am

    #1693327

  • RE: How to return something when there is no record

    Joey Morgan (2/25/2014)

    If she gets any rows, she will get a zero trhough the case statement; that's correct. But if there are no rows she will only get null, and...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    February 25, 2014 at 10:17 am

    #1691990

Viewing 15 posts - 211 through 225 (of 1,228 total)