Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 8,731 total)

  • RE: How to Remove Fragmantaion on INDEX?

    Fill factor is not really defined by the amount of data in the table but on the rate of data modifications.

    To generate some tests, I did the following:

    IF OBJECT_ID( 'STATE_COUNTY_CODES')...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 1:34 pm

    #1819872

  • RE: Query that gives info twice

    Sean Lange (8/13/2015)

    Luis Cazares (8/13/2015)

    For Oracle, the first query should be something like this:

    select *

    from quer a

    cross join (select 'Text1' as MyText FROM Dual union all select 'Text2' FROM Dual)...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 1:07 pm

    #1819860

  • RE: Wildcard Searches

    I could give it a try.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 12:57 pm

    #1819856

  • RE: Introducing the Set-based Loop

    Thank you all for the nice comments.

    You're right Hassan, my code is wrong and that might be the reason for not getting the same results on the 2 approaches. I...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 12:56 pm

    #1819854

  • RE: Query that gives info twice

    Sean Lange (8/13/2015)

    jodevil99 (8/13/2015)

    FROM keyword not found where expected

    select *

    from quer a

    cross join (select 'Text1' as MyText union all select 'Text2') x

    missing keyword

    select *

    from quer a

    cross apply (values('Text1'), ('Text2')) x...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 12:44 pm

    #1819849

  • RE: How to Remove Fragmantaion on INDEX?

    meerack11 (8/13/2015)

    table has 3500 records

    This is the issue, which doesn't represent a problem since it's a small table. Check Ron's comment.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 12:39 pm

    #1819846

  • RE: How to Remove Fragmantaion on INDEX?

    Can you post the table and index creation code including the fill factor?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 11:58 am

    #1819831

  • RE: Query that gives info twice

    Are you using Oracle?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 11:10 am

    #1819811

  • RE: Calculating median over 2 columns

    The DISTINCT keyword is redundant as you're using GROUP BY. You're also giving average which is the mean and not the median.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 10:42 am

    #1819800

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/13/2015)

    Luis Cazares (8/13/2015)

    Eirikur Eiriksson (8/13/2015)

    Grant Fritchey (8/13/2015)

    WayneS (8/13/2015)

    Crystal Ball, report to Aisle 5

    I'm sure that a large part of this is English as a second language. But lordy,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 9:57 am

    #1819780

  • RE: Are the posted questions getting worse?

    GilaMonster (8/13/2015)

    Views upon views upon #$%$%^%$#$ views! The same damn table is getting queried 8 times.

    That reminds me of a job posting I recently received on the mail. Even if...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 9:56 am

    #1819776

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (8/13/2015)

    Grant Fritchey (8/13/2015)

    WayneS (8/13/2015)

    Crystal Ball, report to Aisle 5

    I'm sure that a large part of this is English as a second language. But lordy, can the questions be...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 9:32 am

    #1819757

  • RE: How to increase the performance of the Insertion Sp in While Loop ?

    Just to expand on what Grant said, instead of having this:

    IF EXISTS (

    SELECT insuranceBilling.InsurerID

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 9:07 am

    #1819724

  • RE: Today's Random Word!

    Ed Wagner (8/13/2015)

    eccentricDBA (8/13/2015)

    whereisSQL? (8/13/2015)

    Ed Wagner (8/13/2015)

    Luis Cazares (8/13/2015)

    djj (8/13/2015)

    Queue

    Wait

    Disk

    Storage

    array

    Pointer

    Beagle

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 8:42 am

    #1819705

  • RE: Are the posted questions getting worse?

    jasona.work (8/13/2015)

    GilaMonster (8/13/2015)

    Sean Lange (8/13/2015)

    Every table name and every column name are exactly 6 UPPER case letters.

    I'm working with one of those. Fortunately it's not case sensitive, but the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 13, 2015 at 8:26 am

    #1819692

Viewing 15 posts - 4,396 through 4,410 (of 8,731 total)