Forum Replies Created

Viewing 15 posts - 46,381 through 46,395 (of 59,101 total)

  • RE: OLE Automation help

    Not the login you're using... the login the SQL SERVER is using when it starts up on the network...

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

    December 26, 2008 at 5:20 pm

    #917956

  • RE: What do you look for in a Database Audit?

    There are some things I look for in security... are things like SSN's, Pins, Passwords, Account numbers, or even the "last 4 of the SSN" encrypted? Who has access...

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

    December 26, 2008 at 5:17 pm

    #917955

  • RE: What do you look for in a Database Audit?

    rajib (12/26/2008)

    I hope this kind of open ended question is OK to ask in this SSC forum.

    Thanks

    Absolutely... it does help folks understand if they know you know it's a very...

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

    December 26, 2008 at 5:10 pm

    #917954

  • RE: Are the posted questions getting worse?

    Heh... Now, now, David... it's set up perfectly for an SQL Injection attack... what are you crabbin' about? 😛

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

    December 26, 2008 at 5:06 pm

    #917953

  • RE: Cursors Be Gone!

    Matt Whitfield (12/26/2008)

    Jeff Moden (12/24/2008)

    Matt... I did agree and said so. There's also a bit to be added in retrospect. That's what discussions are about.

    Fair enough. I re-read...

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

    December 26, 2008 at 4:57 pm

    #917952

  • RE: Are the posted questions getting worse?

    bitbucket (12/26/2008)

    Hey can I get a pay raise each time I write some T-SQL that uses cursors and triangular joins and takes forever to run, tying up the server so...

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

    December 26, 2008 at 2:25 pm

    #917936

  • RE: OLE Automation help

    The server you are working on, whether local or remote, must be logged in as a user that can "see" the spreadsheet using a UNC instead of a mapped drive.

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

    December 26, 2008 at 1:42 pm

    #917924

  • RE: Looking Forward

    Steve Jones - Editor (12/26/2008)

    Congrats!

    Hey, pick up running as a new vice, that's what I did 🙂

    http://amileaday.blogspot.com/

    Just bought a nice new Calypso Cruiser (bicycle)... 7 speeds... nice super heavy duty...

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

    December 26, 2008 at 1:34 pm

    #917922

  • RE: Split Names With out VB Script

    ps (12/26/2008)

    Jeff, I must say the way you play around with T-SQL is really amazing. Atleast I couldnt think of using PARSENAME in this example:w00t:

    :blush: That's awfully nice...

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

    December 26, 2008 at 12:58 pm

    #917914

  • RE: Smart Teaching

    Heh... you beat me to it, Barry. Despite some awesome technology in some classrooms and the awesome learned abilities by the students in those classrooms, most still can't count...

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

    December 26, 2008 at 12:36 pm

    #917905

  • RE: What do you look for in a Database Audit?

    rajib (12/26/2008)

    I love the word "depends". 😀

    How about we assume that I'm looking for everything (3 things mentioned above as well as other items not listed there)? I am interested...

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

    December 26, 2008 at 11:39 am

    #917888

  • RE: Looking Forward

    Heh... Actually, I haven't had a cigarette in over a week. Still want one real bad, but trying not to give in. Also trying not to bury folks...

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

    December 26, 2008 at 11:34 am

    #917886

  • RE: Split Names With out VB Script

    Using the test data nicely provided by Pradeep, with an added row...

    create table #patname

    (

    FullName varchar(100),

    FirstName varchar(100),

    MiddleName varchar(100),

    LastName varchar(100)

    )

    insert into #patname(FullName)

    select 'John,David Robert'

    UNION ALL

    select 'sustaita,corie m'

    UNION ALL

    select 'pena,geneva jesus'

    UNION ALL

    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)

    December 26, 2008 at 11:29 am

    #917885

  • RE: Looking Forward

    I have two resolutions....

    1. Stop swearing so much at people who want to do stupid things to databases because... most of them are managers that have some say so...

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

    December 26, 2008 at 10:49 am

    #917869

  • RE: What do you look for in a Database Audit?

    rajib (12/23/2008)

    I am curious to find out what your team does when it comes to database audit?

    Here are a list of questions from me:

    - Do you check schema only 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)

    December 26, 2008 at 10:38 am

    #917865

Viewing 15 posts - 46,381 through 46,395 (of 59,101 total)