Forum Replies Created

Viewing 15 posts - 16,426 through 16,440 (of 59,067 total)

  • RE: Speeding Up Delete's on Large Databases

    Eirikur Eiriksson (10/31/2016)

    Quick suggestion, reading the data to be deleted into a "bucket" variables can drastically speed up the delete, here is an example based on the DDL previously posted.

    /quote]

    Seems...

    --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)

    October 31, 2016 at 10:27 am

    #1909690

  • RE: Emotions and Decision Making

    Eric M Russell (10/31/2016)

    In most shops, trying to argue with application developers on the issue of proper database modeling and SQL coding is a lost cause.

    That's exactly why I got...

    --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)

    October 31, 2016 at 10:25 am

    #1909689

  • RE: ETL separate database

    RVO (10/31/2016)

    Thanks Jeff.

    I'm confused.

    You're saying it's a good idea to have staging tables in a separate database

    but then what do I do with Foreign Keys?

    Flow is the following:

    1. load into...

    --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)

    October 31, 2016 at 10:09 am

    #1909685

  • RE: HELP! I've got to give a talk to our local .NET geek meet on SQL server

    Ross McMicken (10/31/2016)

    LightVader (10/31/2016)

    Jeff Moden (10/30/2016)

    aaron.reese (10/30/2016)

    Agreed. but when you are prototyping it is very likely that you don't have the full story from the business, especially where they need...

    --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)

    October 31, 2016 at 8:11 am

    #1909636

  • RE: Huge tempdb log file

    JarJar (10/31/2016)

    Jeff Moden (10/31/2016)

    JarJar (10/31/2016)

    Thanks guys. FREEPROCCACHE didn't help. In the end I had to restart the SQL service to clear the problem.

    No clarity on what...

    --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)

    October 31, 2016 at 7:58 am

    #1909626

  • RE: Concurrency - Please Provide Comments

    Phil Parkin (10/30/2016)

    But the READPAST hint is one I have not used before ...

    Where most folks have a genuine need for something like WITH(NOLOCK), I usually end up using READPAST,...

    --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)

    October 31, 2016 at 6:48 am

    #1909589

  • RE: Filling the missing rows/gap in the data

    seismicbeat (10/31/2016)

    Hello,

    I have been setting up a database where I can store our sales and activity data, and struggling at some point, since I'm learning on the job. 🙂 But...

    --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)

    October 31, 2016 at 6:36 am

    #1909586

  • RE: Emotions and Decision Making

    From the Article: The emotional baggage we tie to technology leads us to poor choices.

    I DO wish that people on [font="Arial Black"]BOTH [/font]sides would remember that! Frequently, and speaking...

    --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)

    October 31, 2016 at 5:56 am

    #1909581

  • RE: Converting time from datime into INT

    hoseam (10/31/2016)

    declare @dte datetime

    Select @dte = GETDATE()

    @dte = 2016-10-31 11:42:51.920

    Is it possible to convert Time (11:42:51.920) into an INT so that it looks like 114257 ?

    Now that...

    --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)

    October 31, 2016 at 5:38 am

    #1909578

  • RE: Huge tempdb log file

    JarJar (10/31/2016)

    Thanks guys. FREEPROCCACHE didn't help. In the end I had to restart the SQL service to clear the problem.

    No clarity on what caused the problem....

    --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)

    October 31, 2016 at 5:29 am

    #1909576

  • RE: ETL separate database

    RVO (10/30/2016)

    I need to improve ETL.

    Currently it's hard to troubleshoot missing files, bad data issues.

    Very bad Logging, notification.

    I want to create separate "ETLtools" database where I would load staging data...

    --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)

    October 30, 2016 at 9:09 pm

    #1909539

  • RE: sql backup

    barsuk (10/30/2016)

    Copy part took about 15mins earlier today.

    Network Backup takes about 22-24mins for 750GB Database using LiteSpeed Backup.

    That's damned good!

    --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)

    October 30, 2016 at 8:58 pm

    #1909538

  • RE: Are the posted questions getting worse?

    Wryan138 (10/30/2016)

    Hi Jeff,

    Nope I'm a real person. I joined up an I've been reading EVERYTHING on the forum for

    quite a while. The one thing I have noticed is...

    --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)

    October 30, 2016 at 7:26 pm

    #1909535

  • RE: Azure certification for SQL DBA

    tauseef.jan (10/30/2016)

    hi,

    As a DBA I am involved with devising and implementing backup/restore plans, HA/DR solutions, migrating of servers, performance tuning etc.

    I have to agree with Gail and, in that vein...

    --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)

    October 30, 2016 at 7:23 pm

    #1909534

  • RE: Azure certification for SQL DBA

    tauseef.jan (10/30/2016)

    hi,

    maybe i did not make myself clear. I wanted to ask that is 70-533 (implementing and deploying azure ) the right career path to take

    T

    Understood and you made yourself...

    --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)

    October 30, 2016 at 5:22 pm

    #1909530

Viewing 15 posts - 16,426 through 16,440 (of 59,067 total)