Forum Replies Created

Viewing 15 posts - 121 through 135 (of 338 total)

  • RE: Stored Procedures Reconsidered

    Yes marketing is the enemy not the other team members 😀

  • RE: Stored Procedures Reconsidered

    Oh oh double post TimJL

    - edit button 😀

  • RE: Stored Procedures Reconsidered

    Manie: I could not have put better, do what is necessary but also make it suffcient.

    Once its in the accounts ledgers you can't remove it, only jounal it.:P

    Control is everything...

  • RE: Short cut key

    It will just be SSDD 😀

  • RE: Stored Procedures Reconsidered

    Thats why as I posted earlier you build a seperate optomized DAL part for each db. 😉

    That way you have abstraction and performance with the stored procs in each db...

  • RE: Stored Procedures Reconsidered

    The Almighty Data Architect is in charge 😀

    Thou shalt obey his words both developer and DBA alike or suffer in the purgatory of unemployment!

    :D:D:D:D:D:D:D:D:D:D:D:D

  • RE: Stored Procedures Reconsidered

    No the (application)users have acces to the application(s).

    The application(s) has/have access to the stored procs.

    The stored procs have access to the tables.

    This is what is happening using either method -...

  • RE: Stored Procedures Reconsidered

    scott.w.white (7/31/2008)


    sgoldman (7/31/2008)


    I'm not sure where I come down on the issue, but I've got a question for those folks who think stored procedures should always be used to access...

  • RE: MS SQL Server vs processor license

    I would use an integer value based on the expected scale of the data.

    programming one rule to follow is;-

    never compare floating point numbers by equality as this cannot be guarenteed.

    (Due...

  • RE: Stored Procedures Reconsidered

    Well as I said "no" is your answer, same db no need to change your stored procs, you just add the new code that does the new things you require.

    You...

  • RE: MS SQL Server vs processor license

    Hi,

    you design looks a little off, numeric (10,0) instead of int/big int for ID columns are you sure?

    ref: http://support.microsoft.com/kb/q198625/ 😉

  • RE: Stored Procedures Reconsidered

    Seggerman (7/31/2008)


    ...

    in my previous ASP.NET I found myself often needing one indicator from one table - in that case I would string together the SQL needed in code

    ....

    You are just...

  • RE: Stored Procedures Reconsidered

    sgoldman (7/31/2008)


    - Do you find yourself writing a substantial new set of Stored Procedures for each new application? Or do you normally set up the bulk of the...

  • RE: SQL Brain

    john.arnott (7/30/2008)


    [/size][/size]Shaun McGuile posted:

    Yeah and implement a couple of stored procs called blow_to_head and alchol_intoxication which use some sort of fuzzy logic and produce random loss of data and strange...

  • RE: Installers

    Yeah installers should have 'exit' or 'complete' or 'close' on the final button that you click

    just a thought 😉

Viewing 15 posts - 121 through 135 (of 338 total)