Forum Replies Created

Viewing 15 posts - 17,476 through 17,490 (of 59,102 total)

  • 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

  • RE: Strange Performance Issue

    ChrisM@Work (6/14/2016)

    davidlester.home (6/14/2016)

    I did eventually get this to work, though it makes little sense. It turns out that dropping all the indexes on the table was the answer. With indexes...

    --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:32 am

    #1885421

  • RE: copy using xp_cmdshell

    Mr J (1/20/2010)

    I find that running batch files through xp_cmdshell is a much better way to perform dos operations, also you might want to look into forfiles.

    Kindred spirit here 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 8:25 am

    #1885417

  • RE: Interview Questions

    ScottPletcher (6/16/2016)

    Jeff Moden (6/15/2016)

    Sergiy (6/15/2016)

    Actually, your "simple question" does not have a correct answer.

    The only correct answer would be a question in response.

    Probably, more that one question in response.

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

    June 16, 2016 at 8:22 am

    #1885414

  • RE: Database Documentation

    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, start PowerPivot and...

    --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:31 am

    #1885311

  • RE: Database Documentation

    Alexandre Araujo (6/15/2016)

    what is the relevance with sql 16 ?

    I would say "None" and "Why is that important"?

    Edit... ah... now I understand the question. It's because it was posted...

    --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:20 am

    #1885310

  • RE: Stretch Pricing

    Sounds like the oldest trick in the book... "Give them the razor... and then sell them lots of blades." 😀

    Shifting gears a bit...

    From the article:

    Less data should mean much better...

    --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:18 am

    #1885309

  • RE: Introduction to U-SQL and Azure Data Lakes

    Great article! Thanks for taking the time to write it.

    Shifting gears and without having anything to do with the article, I think U-SQL only being available to the cloud...

    --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 12:33 am

    #1885307

  • RE: import from CSV/EXCEL and insert/update into SQL which is backend for payroll software

    K. Glad that works for you. I was also going to try to show you how you could import the Excel file without having to convert it 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)

    June 15, 2016 at 6:52 pm

    #1885299

  • RE: Interview Questions

    Sergiy (6/15/2016)

    Jeff Moden (6/15/2016)

    An interview is the one place where volunteering information can do nothing but good... if you know what you're talking about. When someone asks a simple...

    --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 15, 2016 at 6:38 pm

    #1885298

  • RE: Interview Questions

    Sergiy (6/15/2016)

    Actually, your "simple question" does not have a correct answer.

    The only correct answer would be a question in response.

    Probably, more that one question in response.

    Until your requirements become clear.

    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 15, 2016 at 6:10 pm

    #1885296

Viewing 15 posts - 17,476 through 17,490 (of 59,102 total)