[cfaussie] OT : SQL server over a network

2008-10-12 Thread Scott Thornton
ge- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Monday, 13 October 2008 11:24 AM To: cfaussie@googlegroups.com Subject: [cfaussie] OT : SQL server over a network HI, Its always worth it ( imho ). A year or more ago we went from an aging dua

[cfaussie] OT : SQL server over a network

2008-10-12 Thread Scott Thornton
HI, Its always worth it ( imho ). A year or more ago we went from an aging dual-core machine as our SQL server to a dual quad-core SQL 2005 64bit cluster. Its reliable and blindingly fast. I recall a certain report that took 15 minutes reduce to about 30 seconds. Having 32gig ram per server h

[cfaussie] OT : SQL server over a network

2008-10-12 Thread Scott Thornton
Hi, Typically the install configuration would have your CF server and your Db server separate anyways. I think from memory you will find that SQL server will write to your log first, and then to the physical database table. So don't forget to place your log on a fast disk\network as well. Th

[cfaussie] OT : SQL server over a network

2008-10-12 Thread Steve Onnis
Hey guys Just curioud to know if anyone knows if there is a delay between data being written to an MSSQL data file or if it is immediate. I am looking at storing the SQL data files across a network on a file server and just wanting to try and find out any issues this would cause if something was