Description:
Implementations of the SQL Server.
|
|
|
how to check where integrity constraints are being violated
|
| |
Hello, I have a database that is bulk loaded via BCP scripts (via talend, actually). This is to migrate data from a legacy system to our new system. There are dozens of tables and millions of rows in some of them. During the load we have referential integrity turned off. I have discovered today that a small amount of the data violates the... more »
|
|
|
ASE 12.0.0.8 and Solaris 10 zfs
|
| |
Hi, we plan to migrate to new servers. We run now ASE 12.0.0.8, Solaris 10 on flat files on a ufs device (with mirror). The root file system is now supported on zfs, so we ask if it is possible to use ZFS filesystem for the sybase flat file DB? Raw-devices are not so handy, performance is not the argument.... more »
|
|
|
Reasonable number of table partitions?
|
| |
I'm currently doing the prep for a move from ASE 12.5.4 to 15.0.3 and am looking at table partitioning (in particular range-based partitions) and thinking they could be awfully useful to us. Is there some maximum number of partitions it is reasonable to use? I have data going back up to ten years and am trying to figure out if I... more »
|
|
|
Single user mode question.
|
| |
Dear Experts, I inherited a script written long ago and the first line is to check is the Sybase server in the single user mode or not. I personally never make this test, but may be I am wrong. Question: Is it a good practice for the Sybase server to check what mode is it running? Regards, Serguei.... more »
|
|
|
where to discuss some database design issues (not sybase-specific)
|
| |
I am thinking about how to design a database that can cope with logging web usage statistics. For various reasons, google analytics cannot be used. I am wondering whereabouts on USENET to post. The db is not to be vendor-specific so there is nothing particular about sybase to discuss. Indeed, my prototype may be postgres. If it goes... more »
|
|
|
Recent updates at www.sypron.nl
|
| |
14 June 2009: Recent updates at [link] ------------------------------ --------------- This month's quiz question is about a useful trick with the new-in-15.0.2 'application tracing' feature... [link] My books on ASE and Replication server remain a popular resource for DBAs... more »
|
|
|
big files
|
| |
I store the content of files using sql query "insert ...". With small files all is ok. But I can not to insert big files into table. I have error to increase the procedure cash. I did it, but it has no effect. May be, there are many ways how to insert file to database. Can someone give the solution?... more »
|
|
|
User with read only access.
|
| |
Dear Experts, I need a new user to be created with a read only access to some tables and no access to all other objects. My DBA told me it is impossible in Sybase because all new users belong to the "public" group which has a full access to all objects. So he has to remove access permissions from the group and it will make a lot of problems. I think it could be... more »
|
|
|
version 11 upgrade issue
|
| |
Hi, I'm having a problem getting the 2222 EBF installed on Windows XP. After running the EBF, I was unable to connect to any Sybase DB. After some searching online it appeared that my best bet was to reinstall SQLA11. I finished the reinstall and was able to once again establish connections to my DBs from Sybase Central, however now I can not get... more »
|
|
|
