Skip to main content
M
michaelmuller
Known Participant
September 5, 2006
Question

using SQL Server 2005 Express

  • September 5, 2006
  • 1 reply
  • 293 views
I'm building a turn-key system for a client who needs an inhouse system based on my code. Probably the load will never get heavier than 100 hits a minute at peak, if that. The code was developed using full blown SQL Server. Will SQL code from the full blown run on Express? Does Express come with the saved procedures (ie; sp_columns_rowset)?

In other words, is anyone using Express and if so what's your experience?
    This topic has been closed for replies.

    1 reply

    tclaremont
    tclaremont
    Inspiring
    September 5, 2006
    We are using Express on our intranet. Things are working OK, but the single processor limit and the max of 1 gb of RAM are putting quite a throttle on performance. I must admit that peformance is no better than with the previous Access databases.

    Now that we have "proven concept" with SQL Server Express, I have just put the $$$ in the budget for next year to upgrade to the full blown version of SQL Server.

    ALSO, there is a caveat with regard to using Express with ColdFusion. The description and resultant solution is illustrated here:

    http://www.demirkapi.net/avblog/index.cfm?mode=viewEntry&id=CF028569-CCD2-2132-381C9287F81E1E96



    Sorry this does not fully address your question, but the info might prove valuable nonetheless.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices