Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 15,381 total)

  • RE: T-SQL statement to group rows as multiple childs under single parent

    maruthipuligandla (9/18/2014)

    Hello All,

    I've 2 tables QuestionAnswers and ConditionalQuestions and fetching data from them using CTE join and I'm seeing repetitive rows (not duplicate) like, If you have multiple answers for...

    September 18, 2014 at 7:41 am

    #1746401

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/18/2014)

    Sean Lange (9/18/2014)

    Ed Wagner (9/18/2014)

    Sean Lange (9/17/2014)

    WayneS (9/17/2014)

    Sean Lange (9/17/2014)

    ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3...

    September 18, 2014 at 7:38 am

    #1746397

  • RE: Frequent Index Fragmentation

    Jai-SQL DBA (9/18/2014)

    yes I understood that :)) thanks ...I have changed it to 90 and as I see the fragmentation rate has lower down,it is not that frequent as...

    September 18, 2014 at 7:34 am

    #1746392

  • RE: Are the posted questions getting worse?

    WayneS (9/17/2014)

    Sean Lange (9/17/2014)

    WayneS (9/17/2014)

    Sean Lange (9/17/2014)

    ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before I got here....

    September 18, 2014 at 7:31 am

    #1746385

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/18/2014)

    Sean Lange (9/17/2014)

    WayneS (9/17/2014)

    Sean Lange (9/17/2014)

    ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before I got...

    September 18, 2014 at 7:27 am

    #1746383

  • RE: Are the posted questions getting worse?

    WayneS (9/17/2014)

    Sean Lange (9/17/2014)

    ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before I got here. The ONLY page...

    September 17, 2014 at 3:34 pm

    #1746231

  • RE: Are the posted questions getting worse?

    ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before I got here. The ONLY page on the entire...

    September 17, 2014 at 3:12 pm

    #1746227

  • RE: Filter out Data which exist and not exist both

    I see the issue. The problem is your are using ANSI-89 style joins instead of ANSI-92 style joins. Your join condition causes this to be an inner join and you...

    September 17, 2014 at 2:41 pm

    #1746221

  • RE: Filter out Data which exist and not exist both

    selpoivre (9/17/2014)

    Customer_id = 192618941 Doesn't exist in customer table

    I m using this query

    Select distinct DECODE (d.customer_id, NULL, 'NO', 'YES') EXIST ,e.customer_id from customer e , customer d

    where e.customer_id...

    September 17, 2014 at 1:39 pm

    #1746208

  • RE: Are the posted questions getting worse?

    Roy Ernest (9/17/2014)

    I got someone asking if Cursor will work fast on memory based objects.

    It felt like the OP would upgrade to SQL 2014 so that he/she can make...

    September 17, 2014 at 1:02 pm

    #1746200

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/17/2014)

    Sean Lange (9/17/2014)

    Greg Edwards-268690 (9/17/2014)

    Fine line with falling off the bone and a very slight tug off the bone but it comes off clean.

    I can see where the...

    September 17, 2014 at 11:53 am

    #1746181

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (9/17/2014)

    Fine line with falling off the bone and a very slight tug off the bone but it comes off clean.

    I can see where the 'one bite' can lead...

    September 17, 2014 at 10:32 am

    #1746157

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/17/2014)

    Sean Lange (9/17/2014)

    Ed Wagner (9/17/2014)

    Tell me, where do you get your replacement racks? I need some and just started looking around for them, but no luck yet.

    I...

    September 17, 2014 at 10:25 am

    #1746154

  • RE: Index Defragmentation. How to build test data

    balasach82 (9/17/2014)

    Okey dokey. Being a dev I can shrink the database.

    Would it also increase LOB index fragmentation?

    It will blast the fragmentation through the roof on just about everything which is...

    September 17, 2014 at 9:56 am

    #1746127

  • RE: Index Defragmentation. How to build test data

    balasach82 (9/17/2014)

    Igor,

    Shrinked log file. It didnt frag the indexes in the tables i am testing the Ola Hallengren script.

    I have to understand the script to better customise it for my...

    September 17, 2014 at 9:09 am

    #1746108

Viewing 15 posts - 3,796 through 3,810 (of 15,381 total)