Re: [firebird-support] Aliases and Windows Host - any

2014-05-27 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
Thanks Alexandre, that's exactly it. I'm using a test setup of just 2 computers that I have not used for a while and had not checked. It works perfectly as I guess you knew it would! I still have a text file of Server_Name.Txt that just contains ajd-sony which is hidden, read-only, so I'm not

[firebird-support] nbackup

2014-05-27 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]
Hi all I am using nbackup with a script to do a daily backup of my database. I have a situation where the delta file still exists now and the files are db.fdb size 309 555 date 22 April db.fdb.deltasize 22 500 date 27 May The last nbackup file is dated 22 April so it failed on

Re: [firebird-support] nbackup

2014-05-27 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]

[firebird-support] Re: nbackup

2014-05-27 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
27.05.2014 12:41, Tony Christiansen wrote: I just tried to manually unlock the db.fdb file and that got rid of the delta file but the file size is still 309 555 - I would have expected it to change if the delta is merged with the database. Is there an explanation of what is happening

[firebird-support] filter conditions: WHERE vs. JOIN clause

2014-05-27 Thread jakef...@yahoo.com [firebird-support]
In general, does it make a difference whether the filter conditions are in the JOIN or WHERE clause? In practice, I've always placed the filter conditions in the WHERE clause and just used the ON portion of the JOIN clause to join the tables. We have some new members of our team with a MS

Re: [firebird-support] filter conditions: WHERE vs. JOIN clause

2014-05-27 Thread Tim Ward t...@telensa.com [firebird-support]
On 27/05/2014 16:17, jakef...@yahoo.com [firebird-support] wrote: In general, does it make a difference whether the filter conditions are in the JOIN or WHERE clause? In particular, if there are outer joins you can get different results. -- Tim Ward

Re: [firebird-support] filter conditions: WHERE vs. JOIN clause

2014-05-27 Thread 'E. D. Epperson Jr' dixonepper...@gmail.com [firebird-support]
Jake, I've a background in MS Sql also. Had to look this up before answering, but I don't think your new members know as much as they think they know. In MsSql, if the sql statement is written correctly there is no consistent gain doing it one way or the other. The optimizer sees to that.

RE: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-27 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
Please see attached zip file with questionnaire response regarding our server performance.Also, I have attached restore logs from restore using classic server and restore using super server.Please let me know if you have any question.Thank you,-Halim To: firebird-support@yahoogroups.com From:

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-27 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Halim, firebird-support does not allow attachments. Please put zip with info to some sharing service like ge.tt, and post link here. Regards, Alexey Kovyazin IBSurgeon Please see attached zip file with questionnaire response regarding our server performance.Also, I have attached restore

RE: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-27 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
Here is the link to the zip file: http://ge.tt/1raCY2i1/v/0?c Thank you,-Halim To: firebird-support@yahoogroups.com From: firebird-support@yahoogroups.com Date: Tue, 27 May 2014 21:30:03 +0400 Subject: Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server Hi

SV: [firebird-support] filter conditions: WHERE vs. JOIN clause

2014-05-27 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
In general, does it make a difference whether the filter conditions are in the JOIN or WHERE clause? In practice, I've always placed the filter conditions in the WHERE clause and just used the ON portion of the JOIN clause to join the tables. We have some new members of our team with a MS SQL

Re: [firebird-support] filter conditions: WHERE vs. JOIN clause

2014-05-27 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Tue, May 27, 2014 at 11:17 AM, jakef...@yahoo.com [firebird-support] firebird-support@yahoogroups.com wrote: We have some new members of our team with a MS SQL background, and they have a preference for including filter conditions in the JOIN clause. They say, the predicates in the ON

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-27 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, May 24, 2014 at 7:43 AM, Halim Boumedjirek halim1...@hotmail.com[firebird-support] firebird-support@yahoogroups.com wrote: I used default restore settings and I got over 8 hours of restore time. Increasing the cache size using gfix -b did not help at all. I got the same result. I

Re: [firebird-support] Re: nbackup

2014-05-27 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]

[firebird-support] Re: nbackup

2014-05-27 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
28.05.2014 02:41, Tony Christiansen wrote: Just to clarify, If I do a gbak of a database with a delta file does that backup include the pending changes in the delta file? Sure it does (if those changes are committed ones). Dmitry