Forum Replies Created

Viewing 15 posts - 19,126 through 19,140 (of 59,072 total)

  • RE: UPDATE statement help

    For future posts, help make it easy for people to help you. Please see the first link under "Helpful Links" in my signature line at the end of this...

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

    November 18, 2015 at 9:15 pm

    #1840876

  • RE: Nested Schemas

    Luis Cazares (11/18/2015)

    Carlo Romagnano (11/18/2015)

    patricklambin (11/18/2015)

    I would advice to prohibit this way of coding/naming.

    I disagree, naming conventions should reflect the factory needs. So, it may be that [Sales.XXX] is 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)

    November 18, 2015 at 8:47 pm

    #1840875

  • RE: Referencing function from another database in CREATE TABLE stmt

    SoHelpMeCodd (11/18/2015)

    The model database can be restored to other instances, but each instance must be running the same SQL Server build. And if the master database is rebuilt, the model...

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

    November 18, 2015 at 8:34 pm

    #1840874

  • RE: Positive or Negative

    SQLBill (10/28/2015)

    Jeff Moden (10/26/2015)

    SQLBill (10/26/2015)

    The way I would determine which to use (Active or Inactive) would depend on how I am going to query the data. I use "pseudo...

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

    November 18, 2015 at 6:23 pm

    #1840870

  • RE: Good Basic T-SQL Exercises

    Steve Jones - SSC Editor (11/18/2015)

    Thanks, everyone. Trying to get some learning material for people together.

    I have to ask... what is this all for? Where will this learning take...

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

    November 18, 2015 at 6:01 pm

    #1840869

  • RE: SQL Injection - The Revenge

    Terje Hermanseter (11/18/2015)

    Naming absolutely no names, have you ever run into resistance in implementing what you know to be vital security features?

    Unfortunately, more or less every single day/week at...

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

    November 18, 2015 at 11:50 am

    #1840803

  • RE: SQL Injection - The Revenge

    PHYData DBA (11/2/2015)

    Can you point me to the Compliance regulation that demands SSN be encrypted?

    I've not had to cough up the links in a very long time and the ones...

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

    November 18, 2015 at 11:49 am

    #1840802

  • RE: A Case FOR Cursors...

    No. Like any other software, you find out what went wrong and fix 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)

    November 18, 2015 at 10:21 am

    #1840777

  • RE: 150 GB Backup (compressed) taking over 1 day

    cphite (11/18/2015)

    jbrandenburg (11/17/2015)

    I have been working very closely with the storage admin. He has confirmed things appear to be setup properly. The SQL server and the backup server...

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

    November 18, 2015 at 10:17 am

    #1840776

  • RE: Unable to print the charindex of a special character of its 4th occurrence.

    SQL-DBA-01 (11/18/2015)

    I wanted to generate databases with auto seq no.

    Ah. Thank you and understood. Before you continue down that path, though, consider how many swear words you might...

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

    November 18, 2015 at 10:07 am

    #1840773

  • RE: Unable to print the charindex of a special character of its 4th occurrence.

    SQL-DBA-01 (11/17/2015)

    What's wrong in this query?

    SELECT CHARINDEX('_', name) FirstIndexOf,

    --CHARINDEX('_', name)+1,

    CHARINDEX('_', name, (CHARINDEX('_', name)+1)) SecondIndexOf,

    charindex('_',name, CHARINDEX('_',name,(charindex('_',name ) + 1 )) + 1 ) ThirdIndexOf,

    charindex('_',name,CHARINDEX('_',name,(charindex('_', name ,(charindex('_',name ) + 1 )) +...

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

    November 18, 2015 at 8:38 am

    #1840713

  • RE: upload and store TIF (Image) files into a SQL Server Database

    Andy Warren (11/17/2015)

    Jeff, I've always been a fan of storing them in the db, but it's never one size fits all. The system I support now has 200+ TB -...

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

    November 18, 2015 at 8:35 am

    #1840708

  • RE: A Case FOR Cursors...

    patrickmcginnis59 10839 (11/18/2015)

    Jeff Moden (11/17/2015)

    Hugo Kornelis (11/17/2015)

    I have never found or seen a method for computing running (pre SQL Server 2012) that has comparable performance to a well-programmed cursor solution,...

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

    November 18, 2015 at 8:01 am

    #1840681

  • RE: A Case FOR Cursors...

    Hugo Kornelis (11/18/2015)

    Allow me to shakup your memory. When you first posted quirky update, you had included a good handful of conditions in the article, and swore that those conditions...

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

    November 18, 2015 at 6:58 am

    #1840651

  • RE: Good Basic T-SQL Exercises

    Steve Jones - SSC Editor (11/17/2015)

    Jeff Moden (11/16/2015)

    On #1... is that a trick question? If you have a PK, you shouldn't have duplicates, right? Can you provide more...

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

    November 17, 2015 at 8:26 pm

    #1840520

Viewing 15 posts - 19,126 through 19,140 (of 59,072 total)