Forum Replies Created

Viewing 15 posts - 24,331 through 24,345 (of 59,102 total)

  • RE: Did This Work? - Forum Changes at SQLServerCentral

    Steve Jones - SSC Editor (2/18/2014)

    Jeff Moden (2/18/2014)

    Steve Jones - SSC Editor (2/18/2014)

    Jeff Moden (2/16/2014)

    As I stated peviously, the OP is frequently the worst person to judge answers. You...

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

    February 18, 2014 at 9:55 pm

    #1690143

  • RE: Complicated query with sample data

    smhaig (2/18/2014)

    Wouldn't mind seeing a sample of a worst case CTE and a solution with a temp table, for example.

    Just write a nice little 30 table query into 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)

    February 18, 2014 at 9:52 pm

    #1690141

  • RE: Best way to store images

    To me, the critical question is, is the data important whether it changes or not? If so, put it in the database because no one will protect the 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)

    February 18, 2014 at 9:51 pm

    #1690140

  • RE: To T-SQL or not to T-SQL?

    sqldriver (2/18/2014)

    Jeff Moden (2/18/2014)

    I guess I don't understand the need for any preprocessing here. Just load the each group of files into a working table (heaps, to be sure)...

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

    February 18, 2014 at 9:48 pm

    #1690139

  • RE: Big transaction log file

    MyDoggieJessie (2/18/2014)

    What we can ALL AGREE upon is whichever route you take, please DO NOT SKIP STEP #10

    Heh... I'll drink to 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)

    February 18, 2014 at 9:37 pm

    #1690137

  • RE: 15 minutes Interval from Hours - Please Help

    zulfansari (2/18/2014)

    Hi Guys,

    I'm sorry about the confusion, I guess I should take it step by step, first I need to add a total column as the last column so then...

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

    February 18, 2014 at 9:32 pm

    #1690135

  • RE: Big transaction log file

    SQLRNNR (2/18/2014)

    The real answer is "It Depends"

    How important is the data to your company/client? Do they have an RTO/RPO specified? In other words, what is the maximum allowable...

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

    February 18, 2014 at 3:14 pm

    #1690081

  • RE: compare 2 rows next each other

    Post withdrawn. I thought this was going to turn out to be a massive double triangular join but a second look-see says it probably won'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)

    February 18, 2014 at 3:04 pm

    #1690075

  • RE: Big transaction log file

    cygne17_2 77208 (2/18/2014)

    Hi,

    I found a sql server database with a transaction log file of 65 GB.

    The database is configured with the recovery model option = full.

    Also, I noticed than since...

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

    February 18, 2014 at 2:53 pm

    #1690066

  • RE: To T-SQL or not to T-SQL?

    I guess I don't understand the need for any preprocessing here. Just load the each group of files into a working table (heaps, to be sure) and do your...

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

    February 18, 2014 at 2:44 pm

    #1690060

  • RE: Query all schemas.

    jiayi345 (2/18/2014)

    Say I have 100 schemas all with the table "orders" is there an easy way to write one query to query them all?

    cust1.orders

    cust2.orders

    cust3.orders

    cust4.orders

    etc...

    Yes... write a spot of dynamic SQL...

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

    February 18, 2014 at 11:10 am

    #1690004

  • RE: MSDB Transaction Log filling very fast..

    IIRC correctly, there was a bug that cause this behaviour depending on the INITIAL SIZE and GrOWTH SETTINGS of a database in SQL Server 2005. I believe that SP3...

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

    February 18, 2014 at 9:04 am

    #1689958

  • RE: Did This Work? - Forum Changes at SQLServerCentral

    Steve Jones - SSC Editor (2/18/2014)

    Jeff Moden (2/16/2014)

    As I stated peviously, the OP is frequently the worst person to judge answers. You have to remember that they asked the...

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

    February 18, 2014 at 8:47 am

    #1689949

  • RE: DateAdd - Show past year, 2 years, 3 years

    tonyabrhm (2/18/2014)

    Hi

    I am trying to create a query which shows data from the past 1, 2, 3 4 and 5 years in seperate columns. I beleive I have the within...

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

    February 18, 2014 at 8:41 am

    #1689947

  • RE: Missing Indexes

    BrainDonor (2/18/2014)

    mandir.jain (2/18/2014)

    one scenario may benefit from creating ,other scenarios may not. So how to decide ? how many scenarios to test? 🙂

    Indeed. And somebody has to make the decision...

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

    February 18, 2014 at 8:37 am

    #1689942

Viewing 15 posts - 24,331 through 24,345 (of 59,102 total)