At 01:16 PM 4/10/2002 -0700, you wrote: >Just sold our first CF app... a large manufacturing system. It is based on >our previous client server mfg systems. > >The Installation environment is Windows 2000, SQL Server 2000, and CF5. > >Our development environment is RedHat 7.2, PostgreSQL 7.1, and CF5. > >Two Questions: > >1. Was wondering if anybody has any sage advice about how we install SQL >Server. We have never installed or used it but have been told that there >are several options we might want to select when we install. > >2. Since we were careful to use Generic SQL queries (ANSI 92) we think >that it should run with few adjustments to the code. Is that reasonable?
Yes, it is. Depending on time constraints / budgets / whatever, you may want to consider investigating the use of stored procedures / views / triggers that are specific to SQL Server and may improve performance. >3. What might be considered great source material for learning more about >SQL Server? I have Professional SQL Server 7 (I believe it was updated for SQL Server 2000) and it answered everything I need to know about it. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
