Forum Replies Created

Viewing 15 posts - 361 through 375 (of 1,221 total)

  • RE: can anyone provide me real time scenarios where you build stored procedures, triggers, cursors?

    steve000 (3/9/2015)


    Do you have a sample you would be willing to share? (Stored proc working with csv?) I do SSIS CSV imports all the time!! I didn't know i could...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: can anyone provide me real time scenarios where you build stored procedures, triggers, cursors?

    t.mounika01 (3/6/2015)


    Actually, what i meant was that I just have thereotical knowledge and I have been practicing queries on ssms installed in my laptop. I want to know how...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Fifty Words for Databases

    Eric M Russell (3/9/2015)


    ...Personally, I'd love to move into a greenfield opportunity, even if it meant walking away from a position I've invested years in.

    That's what I'm doing right now,...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Fifty Words for Databases

    tom.artz (3/9/2015)


    Nice article. Unconsciously or unknowingly I have categorized our databases into six categories - a 2X3 array. One axis is disaster / recovery axis with two high level options;...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: I can't get a combo box to populate how I want it to

    Wendell, that did it! What I needed was to add a cboSchool.requery to the On Current of the form. I had the query right, just needed to refresh...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: I can't get a combo box to populate how I want it to

    Thanks, Wendell. I'll give that a shot, that sounds like what I'm looking for. And Piet, I'm not ignoring your approach either.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Upgrade and Refresh, or Not?

    Everything is a risk. Upgrading is risking business disruption, not upgrading is risking having previously unknown low-level vulnerabilities being discovered and exploited, aside from possibly hitting max limits that...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: I can't get a combo box to populate how I want it to

    I am considering that, I'm not yet committed to it. The one good thing is that even though this system will be used state-wide is that I can only...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Why should i go for MS-SQL server not for Oracle and MySQL ?

    podmate (3/4/2015)


    ...I would write a screed about how slow SSRS is, how bloated the report files are and how painful the report builder/bids tools are to use, but then you...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Need to export one table to another database in a different server/db

    Another way you can do it in SQL Server 2014:

    SSMS:

    Right click on the database, select Tasks, select Generate Scripts.

    Click 'Select specific database objects'.

    Expand the Tables tree and click the box...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Find Top 5 executed queries ordered by execution count

    Very interesting! I really should spend some time exploring DMVs, I used to love rummaging around in system tables in older versions of SQL Server.

    Having said that, I'm getting...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Where do senior SQL DBAs land finally?

    patrickmcginnis59 10839 (3/3/2015)


    ...have your "stack smashed for fun and profit."

    Hey! "Smash Your Stack For Fun and Profit!" is the name of my forthcoming intro programming book, how did you...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Access front end with SQL Express backend -- backup options?

    To safeguard yourself against MDB corruption, store as little dynamic information in Access as possible. I've got lookup tables for combo boxes in my current Access project, everything else...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Express Choice

    I have no problem with Express edition. Over the years I've developed scripts and batch files for running DBCCs backups against it via the Win OS scheduler and that's...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Express Choice

    eric.notheisen (2/27/2015)


    ...For example, I was the applications architect on an E-Commerce project for a large insurance company. I needed a server for the purposes of testing the application. ...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 15 posts - 361 through 375 (of 1,221 total)