Question: Do the table partitioning features (fragmenting) in XPS solve the problem of unloading old data in a data warehouse?Specifically, I need to delete up to 400MB of old data
Question: In a data warehouse, loading/transforming data is a significant process. Do Informix non-logged databases provide significant performance gains in loading and transforming data? Answer: YES! Though your needs may
Question: Both of the following questions deal with the extend function; more specifically, how Informix handles dates:1. I’ve used “extend(var, day to day)” in a program since December ’96 with
Question: Oracle 7.3, Microsoft Access 2.0 and up, and Microsoft SQL Server 6.5 all provide methods by which a single SQL command can update a table using multiple values looked
Question: Set explain on fails (sqlcode: 586 (I think) ISAM: 1) (Could not open sqexplain.out). We have plenty of disk space and file permissions. It even failed as “root” in
Question: How can I implement a counter on my page, like the oneyou use, to show how many visitors have been to my site? Answer: The most common way to
Question: I want to create ‘back’ and ‘exit’ buttons that look the same as the’submit’ and ‘reset’ buttons that are in the <FORMS> commands,and place them all together in a
Question: I teach an Internet class to middle school students. Mycomputers only have 33 MHz processors and no multimedia capabilities. Howmuch effect is the processing speed having on my Internet
Question: The graphics on my Web pages are all now in GIF format. Someone told me that I should convert all these GIFs over to JPEG format, because it is