Forum Replies Created

Viewing 15 posts - 17,431 through 17,445 (of 59,067 total)

  • RE: Interview Questions

    Ed Wagner (6/17/2016)

    Sergiy (6/16/2016)

    My point was - the question about finding current time does not have a correct answer without specifying additional conditions.

    And I think that's fine. If 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)

    June 17, 2016 at 7:25 am

    #1885601

  • RE: Are the posted questions getting worse?

    What's really incredible is how powerful integer math solutions can actually be depending, of course, on what you need to do. Sometimes the really old, simple stuff is 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)

    June 17, 2016 at 7:19 am

    #1885597

  • RE: help with "cast"

    rightontarget (6/16/2016)

    Not really, please explain

    To summarize, if all parts of an equation are of the INTEGER datatype (or any integer based datatype), all of the math will be done using...

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

    June 17, 2016 at 7:09 am

    #1885592

  • RE: Interview Questions

    Luis Cazares (6/16/2016)

    Jeff Moden (6/16/2016)

    timwell (6/16/2016)

    Sergiy (6/15/2016)

    My "Location" in the Forum Profile says "Auckland, New Zealand".

    Current time in Auckland, New Zealand is 12:12 pm.

    The "Posted" label indicates Today @ 1:12...

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

    June 16, 2016 at 6:43 pm

    #1885523

  • RE: Running Remaining Balance or Running Subtraction - Partition By Account

    venkyzrocks (6/8/2016)

    Thanks Guys. I was trying to avoid cursors and see if there was a faster solution. I completely detest cursors :), but I guess I had no option 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)

    June 16, 2016 at 5:27 pm

    #1885522

  • RE: Date data manipulation.

    sql_2005_fan (6/10/2016)

    I need to run this query also on sql 2008 database and getting the following error on 2008.

    The Parallel Data Warehouse (PDW) features are not enabled.

    How can I rewrite...

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

    June 16, 2016 at 5:21 pm

    #1885520

  • RE: Identity insert without reseed

    kumarcug (6/15/2016)

    Hi,

    I found the answer after spend a whole day for POC,

    We need to connect to SSMS using "Replication=True" flag in the "Additaional Connection Parameters" tab of connection window. Now...

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

    June 16, 2016 at 1:52 pm

    #1885497

  • RE: Primary Node MSDb is not updatinng

    New persopn (6/15/2016)

    Hi All,

    In our environment we have a cluster setup and always on and we are performing Copy only backup in node 2 and similarly we have backup setup...

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

    June 16, 2016 at 1:37 pm

    #1885492

  • RE: help with "cast"

    rightontarget (6/16/2016)

    Hi all,

    I have a table with following data:

    idcnttotal

    20118015464

    233115464

    27615464

    282215464

    47415464

    I need to come up with 4th column that is: cnt/total, but it gives me 0.

    What do I need to "cast"...

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

    June 16, 2016 at 1:30 pm

    #1885490

  • RE: Interview Questions

    timwell (6/16/2016)

    Sergiy (6/15/2016)

    My "Location" in the Forum Profile says "Auckland, New Zealand".

    Current time in Auckland, New Zealand is 12:12 pm.

    The "Posted" label indicates Today @ 1:12 am.

    That's how I see...

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

    June 16, 2016 at 1:16 pm

    #1885488

  • RE: Missing green arrow on the sql server icon in object explore

    abeljda 60974 (6/16/2016)

    The shift right click on the server from my local machine did the trick for me. That is it allowed me to now start/stop/restart service, thanks Jeff.

    You bet....

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

    June 16, 2016 at 1:14 pm

    #1885487

  • RE: Interview Questions

    Lynn Pettis (6/16/2016)

    Sergiy (6/15/2016)

    Lynn Pettis (6/15/2016)

    So I guess it depends on the company you are interview with as to who may be asking the questions. I would hope...

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

    June 16, 2016 at 10:11 am

    #1885454

  • RE: Interview Questions

    ScottPletcher (6/16/2016)

    Plus, by using CURRENT_TIMESTAMP, I, at least one time, avoid upsetting Celko :-D.

    BWAAA-HAAAA-HAAA!!!! Too funny. That's a pre-requisite for every job, huh? I almost spewed coffee on...

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

    June 16, 2016 at 10:06 am

    #1885453

  • RE: Database Documentation

    ThomasRushton (6/16/2016)

    Jeff Moden (6/16/2016)

    HappyGeek (10/21/2015)

    Not quite sure this is the right place for this, forgive me if I have it wrong. :blush:

    To rapidly document a database I open Excel,...

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

    June 16, 2016 at 10:02 am

    #1885452

  • RE: Database Documentation

    HappyGeek (6/16/2016)

    This has absolutely no relevance to SQL2016 per sa unless it happened the be the installation under consideration. I did think I put the question in the wrong place...

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

    June 16, 2016 at 8:41 am

    #1885425

Viewing 15 posts - 17,431 through 17,445 (of 59,067 total)