3
votes
4answers
145 views
Database Recovery: What Would You Do If…
Title isn't that great, so feel free to change.
Basically, I will describe an issue we had this week. I want to get responses from everyone on what you would have done in the sce …
1
vote
2answers
46 views
Why is after update trigger not fired on changes of a before update trigger SQLA 10
Since we upgraded our Database from 9.0.2. to 10.0.1. one of my trigger constructs is broken.
When a user changes a value in a purchase order line (testchild) the purchase order ( …
1
vote
1answer
40 views
Does SQLA 9.0.2 works on clustered environment?
Can I run SQLA 9.0.2 server on Windows 2003/2008 clustered environment ?
4
votes
2answers
80 views
Vendor Announcement: SQL Anywhere 9.0.2.3924 runs on Windows 7 and 2008
Updated platform matrix: http://www.sybase.com/detail?id=1002288
"SQL Anywhere 9.0.2 running on Windows 7 and Windows Server 2008 R2 tested with EBF #3924"
Download EBF: http:// …
3
votes
3answers
124 views
Sql COUNT Performance Question
Structure of Example table:
Id, Integer (PK)
Name, Varchar(100)
Description, Text
I need to know if exists difference in performance between:
SELECT COUNT(*) FROM Example;
an …
3
votes
2answers
64 views
What should I review when I migrate from 9.0.2 to 11.x?
What should I review (stored proc, view, select, etc) before migrate an database (with about 66gb) from ASA 9.0.2 to SQLA 11?
1
vote
3answers
48 views
Recovery with 2 transaction logs issue
I loose my database file. To recovery, I'm getting last full backup and trying to apply the only one transaction log backup and current log.
I'm using dbeng9 database.db -a back …
