Forum Replies Created

Viewing 15 posts - 3,376 through 3,390 (of 3,617 total)

  • RE: What did you do before SQL?

    Keith,

    You sound as disillusioned with UK Education as the parents who care!

    My experience of school IT was 30 of us kids sharing a Commodore pet, then shortly afterwards having 8...

  • RE: Where Do I Want To Go Today? - From the Field 2

    I would like the following features within Yukon.

    • Upgradeable MS XML component. At present SQL2000 locks you into MS XML3.0
    • Not really a SQL Server issue but ...
  • RE: What did you do before SQL?

    I always wondered what it was that made something other than an animal masculine or feminine.

    Someone told me that in French if a bloke liked it then it would be...

  • RE: What did you do before SQL?

    I tend to think that software engineers are to programmers what mechanical engineers are to car mechanics.

  • RE: What did you do before SQL?

    • Fruit picker
    • Gardener
    • Odd job man
    • Commodore Pet Basic and 6502 programmer
    • dBASE II/Clipper programmer
    • HP3000 Image3000 programming
    • Cognos Quiz programming
    • VB Access SQL developer
    • Dad
    • Statistician
    • Web DBA and CMS Specialist

    Still doing...

  • RE: Where Do I Want To Go Today? - Real Time Defragging

    I've seen an article somewhere describing how existing file systems such as FAT & NTFS are going to be replaced by databases. The argument was that the existing file...

  • RE: Dubious DBA Statement

    Thanks Tom, that is a very clear description.

    Does anyone know if this a generic SQL Server/Sybase issue. I see that alzdba has experienced it with SQL7 SP2 but does...

  • RE: Dubious DBA Statement

    quote:


    How "vast" are we talking? Hundreds/sec? thousands? Do you have any idea of peak v avg numbers?


    September 8, 2003 at 10:45 am

    #473057

  • RE: Stored Procedure Development Cycle

    Philip,

    What you need is a good document managements system plus the internal procedures in place to use it.

    Ideally the documents need version control so I would say have an official...

  • RE: Stored Procedure Development Cycle

    Yep, agree with all this but I would add documentation to the list.

    The situation I am in is where the stored procedures are effectively an interface to the database layer....

  • RE: MS03-033 or MDAC 2.8 Which would you install?

    If there is a new configuration change then the main thing is to test it away from potentially embarassing situations.

    We got stung in the jump from 2.5 to 2.6 because...

  • RE: Where Do I Want To Go Today? - Upsert

    I like the idea behind WITH UPDATEEXISTING.

    I feel it needs three settings.

    • ON - Does what it says on the tin.
    • OFF - Performs INSERTS only but throws errors if ...
  • RE: Match firstname lastname

    How are you going to cater for Rob, Bob, Robert, Robin, Bert. They could all be the same person or they could be all different.

    Speaking as someone who has...

  • RE: Simple Enough..

    Try this instead

    CREATE Procedure p_get_customerdetails

    /* Param List */

    @Customer_ID int,

    @view Int =0 AS

    Set NOCOUNT ON

    /*

        0 = CustMain

        1 = Devices

        2 = Setup

        3 = trxHist

    */

    IF @view = 0

        BEGIN

            SELECT * FROM vw_CUSTOMER...

  • RE: SQL Server Considerations

    Visual Studio has a tool called "Application Performance Explorer". I have to admit that I've never used it, but it is there.

    I've heard of a tool called SQL HAMMER,...

Viewing 15 posts - 3,376 through 3,390 (of 3,617 total)