Forum Replies Created

Viewing 15 posts - 16,921 through 16,935 (of 59,101 total)

  • RE: Prevent DB creation

    Sreejith! (8/31/2016)

    Hello,

    I would like to prevent users from creating databases on a specific disk(say D :),as there is not enough room for any new DB's & available space can be...

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

    September 1, 2016 at 6:31 am

    #1898739

  • RE: Estimate single record growth size calculation

    SQL Galaxy (9/1/2016)

    Hi.

    There is one table record counts are one month total = 199034556, so how can we estimate total estimate size of table?

    Per Record size 8KB, 199034556*8 = 1592276448KB,...

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

    September 1, 2016 at 4:54 am

    #1898721

  • RE: Avoiding Stored Procedures

    David.Poole (8/31/2016)

    Indianrock (8/31/2016)

    Is this relevant? Hardware may be cheaper than experienced developers and DBAs who could actually develop the sophisticated procs which could handle complicated business logic.

    In many of...

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

    August 31, 2016 at 11:02 am

    #1898610

  • RE: Email Formatted HTML Table with T-SQL

    tgqthi (8/30/2016)

    Jeff Moden (3/15/2016)

    tauseef.jan (3/15/2016)

    Thankyou so much for the code snippet.

    But I have a problem, that I have EMPTY(NULL) columns.

    because of this the columns in the email get shifted 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)

    August 31, 2016 at 10:02 am

    #1898602

  • RE: xp_cmdshell Error code: 0x80004005

    Again (and I haven't read back through this entire thread), I hope that you did NOT give a non systemadmin privs to run xp_CmdShell directly.

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

    August 31, 2016 at 9:59 am

    #1898601

  • RE: Avoiding Stored Procedures

    David.Poole (8/31/2016)

    I strongly suspect that developer antipathy to stored procedures is rooted in organisation structure rather than pure technical arguments.

    • Stored procs being seen as a DBA thing taking...

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

    August 31, 2016 at 9:48 am

    #1898594

  • RE: Mortgage amortization table

    Sergiy (8/31/2016)

    But in this case they cannot be blamed.

    They did not create any mess.

    Because there is no mess.

    It's all done right, exactly according to the rules of fixed point computations.

    I'll...

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

    August 31, 2016 at 9:27 am

    #1898586

  • RE: OPENROWSET linked server "(null)" error

    ash_m (8/31/2016)

    Thank you Jeff.

    I tweaked code a bit by introducing a view and it worked!

    I created a view in ash_test procedure which holds the required output data (that way ignored...

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

    August 31, 2016 at 12:39 am

    #1898463

  • RE: Mortgage amortization table

    Sergiy (8/30/2016)

    Jeff Moden (8/29/2016)

    Heh... let's hope the programmers in the IRS aren't using FLOAT to make decisions.

    You better hope they do.

    Why - see below.

    DECLARE @Amount MONEY, @Term INT

    DECLARE @fRate float,...

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

    August 31, 2016 at 12:14 am

    #1898459

  • RE: Mortgage amortization table

    The problem is that MS made the decision to truncate to a scale of 6 whenever the precision of the DECIMAL datatype goes over 38 instead of doing what Granny's...

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

    August 30, 2016 at 11:54 pm

    #1898458

  • RE: OPENROWSET linked server "(null)" error

    ash_m (8/30/2016)

    Hi Jeff,

    Data doesn't get loaded in temp table, fails at EXEC(@tempsql) statement.

    Error:

    Cannot process the object "exec ash_test". The OLE DB provider "SQLNCLI11" for linked server "(null)" indicates that either...

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

    August 30, 2016 at 9:53 pm

    #1898453

  • RE: OPENROWSET linked server "(null)" error

    I've not done a detailed look at your code but it looks like you have pretty much everything covered except the possible problems that may occur with concurrency due 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)

    August 30, 2016 at 9:01 pm

    #1898450

  • RE: Are the posted questions getting worse?

    WayneS (8/29/2016)

    Y.B. (8/29/2016)

    WayneS (8/29/2016)

    jasona.work (8/29/2016)

    Brandie Tarvin (8/29/2016)

    Well my thought is that there are many people who are absolutely terrified of interviews, who don't see themselves doing well no matter 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)

    August 30, 2016 at 12:39 am

    #1898216

  • RE: OPENROWSET linked server "(null)" error

    ash_m (8/29/2016)

    Hi Jeff,

    Thank you for your reply.

    I've a generic procedure which prints messages on screen and used in validation step in other procedures.

    Ex: Print error message if querying table doesn't...

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

    August 30, 2016 at 12:27 am

    #1898214

  • RE: Mortgage amortization table

    Heh... let's hope the programmers in the IRS aren't using FLOAT to make decisions.

    DECLARE @Amount MONEY, @Term INT

    DECLARE @fRate float, @dRate decimal (38,15)

    SELECT @Amount = 1000000, @Term = 17*3*13*7*19*23*43*11

    SELECT @Term

    SELECT...

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

    August 29, 2016 at 11:36 pm

    #1898209

    • Viewing 15 posts - 16,921 through 16,935 (of 59,101 total)