Forum Replies Created

Viewing 15 posts - 17,596 through 17,610 (of 59,069 total)

  • RE: When query is too long for OLE DB DFT, what are my options for bridging two servers?

    polkadot (5/25/2016)

    At deployment time I asked that a linked server be created, but I was told the linked server qualified table names inside my sproc would not be supported and...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 25, 2016 at 9:55 pm

    #1881481

  • RE: The Clustered Index is not the Primary Key

    Steve Jones - SSC Editor (5/24/2016)

    vliet (5/24/2016)

    Well, heaps do have a slight advantage in certain cases. Because SQL Server ...

    I really dislike opening statements like this. You are almost implying...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 25, 2016 at 9:36 pm

    #1881479

  • RE: Temp DB filling on simple update statement?

    krypto69 (5/25/2016)

    Hi,

    I have a pretty simple update statement:

    UPDATE eligibility

    SET primary_plan = 0

    FROM temp_eligibility e

    WHERE eligibility.eligibility_id = e.eligibility_id

    This statement is updating around 7 million rows. Problem is it is filling up...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 25, 2016 at 9:12 pm

    #1881478

  • RE: Are the posted questions getting worse?

    ThomasRushton (5/25/2016)

    jasona.work (5/25/2016)

    So, I'm working on getting a new server setup, doing the initial migration of the customer DBs to the server, and I found myself wondering...

    Does anyone, when they're...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 25, 2016 at 8:02 am

    #1881323

  • RE: Data modeling TECHNIQUES

    Rankerg (5/24/2016)

    Hi

    So I will have 1xtra phone number table with customer ID as a foreignkey right? And what do you mean by business requirements for data usually it's business...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 24, 2016 at 11:59 am

    #1881174

  • RE: Recreating tables from a list of tables

    Andre 425568 (5/24/2016)

    I did rebuild before this, but still there were tables with over 80% fragmentation

    For smaller tables, SQL Server doesn't always rebuild an index even if you told it...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 24, 2016 at 8:12 am

    #1881106

  • RE: Data modeling TECHNIQUES

    Grant Fritchey (5/24/2016)

    If you have the business requirements for the data, by and large you should be able to design the tables without reference to a GUI that's going to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 24, 2016 at 8:09 am

    #1881104

  • RE: Pivot help

    Luis Cazares (5/24/2016)

    You have several code smells in there. Some of them are:

    - Using functions in your WHERE clause

    Just to clarify... having functions in your WHERE clause isn't a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 24, 2016 at 8:04 am

    #1881101

  • RE: Recreating tables from a list of tables

    Andre 425568 (5/23/2016)

    We found that fixing this brings fragmentation down by anything from 0-60 % after doing table rebuilds, after rebuilds we staill have fragmentation on tables and indexes. We...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 23, 2016 at 4:59 pm

    #1880932

  • RE: Monitoring Backups !!

    rk1980factor (5/23/2016)

    35 servers, 42 instances on those 35 servers, 84 database on those 42 instances.

    All servers are on virtual environment (vmware)

    all backups store in SAN drive (LUN) D:\drive for all...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 23, 2016 at 4:44 pm

    #1880908

  • RE: Dynamic Tablix

    Charmer (5/23/2016)

    Hi Jeff,

    It's not just 3 tables bcoz its not fixed...

    The tablix creation depends upon how many values we pass.

    But as far as I know, even if creating dynamic tablix...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 23, 2016 at 4:38 pm

    #1880902

  • RE: Backups now taking over 24 hours!

    TheSQLGuru (5/23/2016)

    Jeff Moden (5/23/2016)

    anthonystevens (5/23/2016)

    Looks like it was a problem with our SAN. Thanks for the help and advise.

    What kind of problem?

    Also, why are you wasting valuable SAN space...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 23, 2016 at 4:32 pm

    #1880901

  • RE: How to reduce the database size of the User DB's

    Database admin(DBA) (5/23/2016)

    Thank you jeff for your quick response.

    Total size of the indexes is around 98GB.Waiting for your suggestions to proceed further.

    Look at what I asked. I need to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 23, 2016 at 4:26 pm

    #1880900

  • RE: How to reduce the database size of the User DB's

    Database admin(DBA) (5/23/2016)

    Thank you all for your information/suggestions.

    But for your information,The requirement is need to reduce size of the database and here Data file free space available around 98.5...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 23, 2016 at 9:10 am

    #1880802

  • RE: Backups now taking over 24 hours!

    anthonystevens (5/23/2016)

    Looks like it was a problem with our SAN. Thanks for the help and advise.

    What kind of problem?

    Also, why are you wasting valuable SAN space to store backups?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    May 23, 2016 at 9:07 am

    #1880800

Viewing 15 posts - 17,596 through 17,610 (of 59,069 total)