Forum Replies Created

Viewing 15 posts - 17,626 through 17,640 (of 59,102 total)

  • RE: Rebuild index job is causing index corruption?

    Seems like you uncovered a bug. Unfortunately, they not going to fix it because it's in a version of SQL Server that has been out of support for quite...

    --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 29, 2016 at 5:39 pm

    #1881956

  • RE: SQL back Job is failing

    ramana3327 (5/27/2016)

    Hi,

    I created a maintenance plan for backup. The job is failing with the error

    The job failed. The owner (TestUser) of job MaintenancePlan.Subplan_1 does not have server access.

    The TestUser...

    --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 28, 2016 at 12:11 pm

    #1881927

  • RE: Redirect requests to new Database in same instance

    GonnaCatchIT (5/28/2016)

    I know that option, but want to know if SQL Server supports redirection to different database.

    Issue is we dont have control over the SQL servers and there are lot...

    --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 28, 2016 at 11:33 am

    #1881926

  • 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

Viewing 15 posts - 17,626 through 17,640 (of 59,102 total)