Forum Replies Created

Viewing 15 posts - 91 through 105 (of 1,228 total)

  • RE: Execution Plan Question

    Brandie Tarvin (8/17/2016)

    ChrisM@home (8/17/2016)

    If you could have posted a .sqlplan you would have done so in your first post. What about a picture of the properties sheet for the data...

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

    August 17, 2016 at 12:35 pm

    #1896008

  • RE: Are the posted questions getting worse?

    drew.allen (8/17/2016)

    I'm writing an article explaining my solution to Credits and Debits and am looking for two or three people to review it before I submit it. Any takers?

    Drew

    Definitely.

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

    August 17, 2016 at 12:14 pm

    #1895997

  • RE: Execution Plan Question

    If you could have posted a .sqlplan you would have done so in your first post. What about a picture of the properties sheet for the data reader operator of...

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

    August 17, 2016 at 11:44 am

    #1895989

  • RE: Execution Plan Question

    How are rows selected from the big left-joined table - only the join, or is there also a filter in the WHERE clause?

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

    August 17, 2016 at 11:26 am

    #1895981

  • RE: Are the posted questions getting worse?

    Luis Cazares (8/5/2016)

    jasona.work (8/5/2016)

    SQLRNNR (8/5/2016)

    jasona.work (8/5/2016)

    So, something completely different!

    Movie review of the new Bourne movie (kept short)

    Pros: Decent enough typical action movie.

    Cons: Oh god the mangling and mis-use...

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

    August 5, 2016 at 11:27 am

    #1894118

  • RE: Temp Table vs Permenant Table

    Post your code. Reduce the pointless guesses. Thanks.

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

    July 22, 2016 at 12:59 pm

    #1891661

  • RE: Subquery Question

    SQLPain (7/13/2016)

    Thanks Guyz

    I connected it one more time with itself and used the MAX function, which kind of solved my problem.

    I know this is not an ideal thing to do

    SELECT...

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

    July 13, 2016 at 9:55 am

    #1889909

  • RE: Sequence generation

    TheSQLGuru (7/12/2016)

    Note that you only need the ROW_NUMBER() stuff if you are inserting multiple rows in one batch. If you are like almost all of the clients I come across...

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

    July 12, 2016 at 12:30 pm

    #1889698

  • RE: Date Range overlaps

    J Livingston SQL (7/11/2016)

    nope

    http://ark.intel.com/products/88195/Intel-Core-i7-6700K-Processor-8M-Cache-up-to-4_20-GHz

    Has to be tested on steam-powered lappy here then. Dreckly.

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

    July 11, 2016 at 1:11 pm

    #1889503

  • RE: Date Range overlaps

    J Livingston SQL (7/11/2016)

    sql restarted

    10 runs each

    comment ms

    CJM2 ...

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

    July 11, 2016 at 12:58 pm

    #1889499

  • RE: Using the case statement to show a particular column code

    MMITTAL 758 (7/1/2016)

    Hi,

    I'm trying to add a condition in sql where I have used &regiondivision and &divisionid as variables. I want if the case 1st condition is satisfied then 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]

    July 1, 2016 at 2:06 pm

    #1888158

  • RE: Query

    Phil Parkin (6/30/2016)

    Nice solution, Chris.

    Thanks Phil :blush: I learned it from you 🙂

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

    June 30, 2016 at 2:54 pm

    #1887976

  • RE: search address records using addressline1

    Use IN with a list of possible values:

    IN("8 Park Lane","8,Park Lane","8, Park Lane").

    Construct these values from your input.

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

    June 19, 2016 at 8:30 am

    #1885769

  • RE: What is SQL Fertilization any links?

    Ed Wagner (5/31/2016)

    GSquared (5/31/2016)

    I've seen plenty of BS in databases, but I've never seen anyone advertise for it in a job description...

    Now that's along the same lines I was thinking...

    [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 31, 2016 at 11:40 am

    #1882229

  • RE: Need help on query performance

    Sergiy (5/26/2016)

    ChrisM@home (5/26/2016)

    Using a clustered index like so:

    CREATE CLUSTERED INDEX [cx_Stuff] ON [dbo].[ann_events_Tech_Details]

    ([source] ASC, [start_time] ASC)

    Such clustered may be very good on query but it's gonna be a very high...

    [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 27, 2016 at 4:40 am

    #1881768

Viewing 15 posts - 91 through 105 (of 1,228 total)