Forum Replies Created

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

  • RE: How would you parse 000.024.000 into 24H?

    NineIron - Wednesday, March 28, 2018 6:22 AM

    My table holds values like 000.004.000, 000.02.000, 000.024.000. What is the best/easiest way to get...

    [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 28, 2018 at 7:03 am

    #1984776

  • RE: query just runs; possible join issue?

    Eirikur Eiriksson - Sunday, March 4, 2018 12:31 AM

    jeffshelix - Saturday, March 3, 2018 9:37 PM

    [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, 2018 at 4:38 am

    #1981880

  • RE: Query Taking more time to Run

    jkramprakash - Sunday, March 4, 2018 3:52 AM

    AND EXISTS(SELECT 1
        FROM
         (SELECT DISTINCT
           F_ALIAS,
           F_DATA_CODE,
           STUFF((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]

    March 4, 2018 at 4:30 am

    #1981879

  • RE: How to handle very large dataset

    NineIron - Monday, February 26, 2018 12:00 PM

    See attached.

    "idx_income" is an odd name for a heap! Why don't you have a clustered...

    [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 26, 2018 at 12:40 pm

    #1981174

  • RE: How to handle very large dataset

    The optimiser will do this anyway but simplify your query and you clarify the index requirements:

    SELECT MAX(

    [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 26, 2018 at 11:41 am

    #1981162

  • RE: Problem with Tuning of Delete Statement

    There's an error in the sample datascript:

    Create

    [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, 2018 at 3:52 am

    #1974804

  • RE: Are the posted questions getting worse?

    Ed Wagner - Wednesday, January 3, 2018 1:18 PM

    ChrisM@Work - Wednesday, January 3, 2018 10:11 AM

    [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 3, 2018 at 1:43 pm

    #1974341

  • RE: Date Ranges - Simple, but seemingly impossible

    ScottPletcher - Tuesday, November 7, 2017 2:02 PM

    Based on what's been show so far, I believe the best clustering key for this...

    [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 7, 2017 at 2:07 pm

    #1967062

  • RE: Need you help on to find wait type

    Database admin(DBA) - Wednesday, October 25, 2017 2:09 PM

    Hello All,
    Need your help on TSQL Script to  find which wait type is running...

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

    October 26, 2017 at 2:34 pm

    #1965394

  • RE: Something interesting about patindex

    Alan.B - Tuesday, October 17, 2017 12:59 PM

    This query:

    SELECT
    [charindex] = charindex('',''),
    [patindex] = patindex('','');
    Returns:

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

    October 17, 2017 at 1:38 pm

    #1964098

  • RE: Select data based on multiple date criteria

    Jim-S - Tuesday, October 17, 2017 7:56 AM

    Hi Guys,

    My company are looking at sending out customer satisfaction surveys to our customers. There...

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

    October 17, 2017 at 11:13 am

    #1964072

  • RE: Using Date in Where Condition

    Phil Parkin - Saturday, October 7, 2017 9:47 AM

    aloshya - Saturday, October 7, 2017 9:36 AM

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

    October 7, 2017 at 3:25 pm

    #1962744

  • RE: Optimize WHERE predicate

    vsamantha35 - Thursday, August 24, 2017 11:58 AM

    Hi Chris,
    I tried  to create  those covering indexes  but i  didnt see much  improvement...

    [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 24, 2017 at 12:14 pm

    #1956700

  • RE: CASE expression in GROUP BY clause

    vsamantha35 - Wednesday, August 23, 2017 1:33 PM

    Hi Experts, 

    Can  this below sql statement be optimized? There are some 40 lakh odd records...

    [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 23, 2017 at 1:54 pm

    #1956488

  • RE: Optimize WHERE predicate

    vsamantha35 - Wednesday, August 23, 2017 1:20 PM

    Hi All,

    Help required in re-writing below WHERE predicate so that an index on date...

    [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 23, 2017 at 1:47 pm

    #1956485

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