Forum Replies Created

Viewing 15 posts - 106 through 120 (of 1,228 total)

  • RE: Need help on query performance

    jc85 (5/25/2016)

    ChrisM@Work (5/25/2016)

    jc85 (5/25/2016)

    How should i post the table with data on this forum?

    How many rows do you need for ann_events_Tech_Details table?

    ChrisM@Work (5/25/2016)

    Ideally you would do this by posting 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]

    May 26, 2016 at 9:38 am

    #1881605

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (4/14/2016)

    Chris M and a good chat

    😎

    Don't listen to him he's drunk as usual 🙂

    [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]

    April 14, 2016 at 12:28 pm

    #1872138

  • RE: Finding best matched/covering time period/s against a time period search

    jewel.sacred (3/22/2016)

    Yes, I can fully understand this as I have experienced it as well in past. 🙂 I really appreciate the help been provided. But I already mentioned this criteria...

    [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 22, 2016 at 1:09 pm

    #1866920

  • RE: Finding best matched/covering time period/s against a time period search

    jewel.sacred (3/22/2016)

    Thanks. Very interesting indeed. But it fails for the following criteria

    SELECT @DateStart = '20160425', @DateEnd = '20160501';

    The result should have been

    PrimaryKeyIDDateStartDateEnd ...

    [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 22, 2016 at 12:40 pm

    #1866906

  • RE: Dropping primary key improves performance

    Lynn Pettis (3/17/2016)

    smithhead (3/16/2016)

    Thanks, yes, I updated statistics. In the interest of being able to show it conveniently here I reduced the query down to a very simple example....

    [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 17, 2016 at 3:18 pm

    #1866022

  • RE: current and time-expired rows.

    Hi Ben

    A few questions for you based on the information you've posted so far.

    The model system you have posted - does this model a production system or a system in...

    [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 22, 2016 at 9:00 am

    #1860117

  • RE: Join & Update

    That may be an unrestricted update. The left-joined table contributes nothing, and the WHERE clause is an unpredictable mess of AND and OR. What exactly are you trying to do?

    [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 13, 2016 at 5:15 am

    #1858567

  • RE: Left Join to Temp Table Not Returning All Records

    Put the WHERE clause into the join.

    [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 3, 2016 at 11:39 pm

    #1856459

  • RE: sp execution performance issue

    bala2 (2/3/2016)

    Hi All,

    Today i have heard a strange issue from apps team.

    We have store procedure on one of our sql server 2008 server database. When we ran that sp(sp_new)

    manually it...

    [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 3, 2016 at 2:10 pm

    #1856411

  • RE: the use of CTEs

    Jeff Moden (1/7/2016)

    Jason A. Long (12/24/2015)

    Unless you're using recursion, a CTE can be rewritten as a derived table... Considering that derived tables (and CTEs) are processed before the outer query,...

    [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]

    January 7, 2016 at 1:02 pm

    #1850331

  • RE: simplifying a complicated delete statement

    Magy (1/7/2016)

    I have this complex delete statement.

    I was wondering if there's a way to simply it? I tried formatting, but it still looks complex.

    --delete all entries in the table...

    [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]

    January 7, 2016 at 12:54 pm

    #1850328

  • RE: Help with Cursors

    SQLPain (12/16/2015)

    I have inherited the following code involving cursors which happens to be step1 in a job, currently this step is taking 19 hours to run, there has to be...

    [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]

    January 6, 2016 at 11:09 am

    #1849963

  • RE: How to pad a string with spaces when size of data is unknown

    djj (12/16/2015)

    One more thing to teach. How to ask a question. 😀

    Did you have to ask that? 😉

    [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]

    December 16, 2015 at 1:01 pm

    #1846411

  • RE: Where does the calculation logic is on the “SUPPLY” column come from this SQL

    nileshbgp123 (11/18/2015)

    Thanks a lot for your reply, as i said earlier i am not so good in SQL, Can you please just explain me how the value of SUPPLY is...

    [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]

    November 18, 2015 at 2:07 am

    #1840560

  • RE: Aligning 2 rows into 1 row

    Suth (11/13/2015)

    Getting a error

    Msg 245, Level 16, State 1, Line 1

    Conversion failed when converting the varchar value ',' to data type int.

    In the APPLY block, cast r.id to varchar(n),...

    [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]

    November 13, 2015 at 10:49 am

    #1839676

Viewing 15 posts - 106 through 120 (of 1,228 total)