Indexing on Large table
Hi, Is indexing on 5 keys of a table containing 100 fields more slower than indexing on same 5 keys of a table containing 150 fields. Both the tables (one containing 150 fields and other containing 100 fields) are similar except the 50 attributes which are redundant. Suppose there are 2 attributes common to both [...]

Answer Question   |  November 23, 2005  8:08 AM
Database, DB2, Oracle

Using Query returned values in Oracle Graphics 6i
Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the colors dynamically to the sub-categories based on the [...]

Answer Question   |  November 28, 2005  7:08 AM
Billing and customer care, Billing Support Systems, Business/IT alignment, Career development, Database, DB2, Desktops, Development, Financials, Human Resources, Intelligence, Interaction Center Technology, Maintenance Management, Management, Manufacturing, Marketing/Sales, Microsoft Windows, Oracle, Order Management, OS, Procurement, Product Lifecycle Management, Project management, Projects, Security, Servers, Service, Software, SQL, SQL Server, Supply Chain Planning, Training

SQL Server 2005 adoption
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to use than [...]

Answer Question   |  November 23, 2005  3:36 PM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows

Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2
I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I [...]

Answer Question   |  November 22, 2005  5:36 PM
3Com, Active Directory, ActiveX, Administration, Apache, Automated, Availability, BASIC, Benchmarking, Business Objects, C, Cabling, Cape Clear Cape Connect, Career development, Cisco, Clustering, Cognos, Crystal Reports, Data analysis, Data Junction, Data management and storage, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Dell, Desktop management applications, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterprise Desktop, Ethernet, Fault isolation, Fax and print management, FDDI, File, Frame Relay, Functional, H.323, Hardware, Hardware selection and management, Hewlett-Packard, Hewlett-Packard Application Server, Hubs, Hyperion, IBM, Informatica, Information Builders, Interoperability, Lifecycle development, Linux, Lotus Domino, Management, Manufacturing applications, Microprocessors, Microsoft Systems Management Server, Microsoft Windows, Migrations and upgrades, Monitoring, NCR, NCR/Teradata, Network applications management, Network connectivity, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NIC, Novell IPX/SPX, Oracle, OS, Performance and availability, Performance management, Performance/Load, Ping, Power management, Printers, Programming Languages, Protocol analysis, Remote management, Routers, SAP, SAS Institute, Security, Servers, Software, Software testing, Software testing tools, SPSS, SQL Server, standards, Storage, Switches, Systems management software, TCP, Tech support, Thermal controls

sql query
There are 2 tables POLICY and NAME. The relationship between Policy and name is only the policy number. and ther relation ship is like many to one. I mean several policy number can have same name in the name table with that many records. Now my question is to find out the policy numbers having [...]

Answer Question   |  November 18, 2005  11:36 AM
Database, DB2, Oracle

SQL Query Perfomance Issue.
Hi All, This is Wasim Ahmed. I basically wanted a kick start to tune my SQL Queries for performance. I have a huge query which is taking an average of 30seconds for records in thousands. I want to improve the efficiency of the Query. Can any one help me in this. I am pasting my [...]

Answer Question   |  November 18, 2005  8:31 AM
Automated, ERP, Oracle, Performance/Load, Software testing, Software testing tools, Windows

Oracle 9i clone
Hi I’m trying to clone my production db ona Sun box, NOT using RMAN. No problems with creating controlfile and dbf copies etc. I edit the controlfile create script and try to bring up the ‘new’ database and have a load of errors trying to recover the logfiles, even though startup without recovery. Would I [...]

Answer Question   |  November 20, 2005  10:48 AM
Oracle

Memory (helpfield) usage in Microsoft Access with VBA
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA [...]

Answer Question   |  November 17, 2005  7:59 AM
Access, Database, DB2, Oracle, VBA

Profile default values
I understand how and why profiles are used. My question is; what are the default values for each resource. For example when a profile has the ‘Connect Time’ as ‘Default’ what is the value of the ‘Connect Time’? I would like to know all the ‘default’ values for all the resources to properly set the [...]

Answer Question   |  November 16, 2005  12:23 PM
Oracle

Delete maximum records in a table
Hi! I need to Delete maximum records in a table that has 2 columns, such as Ord No. & Part No. Each Part No. can have many Ord Nos. I need to identify the Maximum Ord No per part No & delete the record from the table. Help would be much appreciated! Sarj

Answer Question   |  November 23, 2005  11:29 PM
Database, DB2, Oracle

Database Diagram Tool
Does anyone know of a free database diagram tool? I downloaded DBDesigner 4 (http://www.fabforce.net/dbdesigner4/), but it’s not working the way I would like. I could just create them in Access but that isn’t really ideal. I want to create diagrams of an existing database, not to create a new schema from scratch. Thanks in advance!

Answer Question   |  February 22, 2012  4:00 PM
Data analysis, Data warehousing applications, Database, DB2, Oracle

database down
can anybody tell me how to know “Exactly at what time the database has gone down

Answer Question   |  November 15, 2005  3:14 AM
Database, DB2, Oracle

DB Replication with Oracle
Hi, Is there any possibility to replicate data between an oracle DB and 500 clients with windows laptops: - bidirectional - asynchronous - with filtering on rowlevel - integrating an existing java based web application with Oracle; except for oracle lite? If no, anybody made experiences with other programms implementing an existing webapplication? Thanks best [...]

Answer Question   |  November 14, 2005  9:10 AM
Oracle

sqlplus killed
when i say SQLPLUS at $ prompt it is saying KILLED, hence i could not able to connect to my database. can anybody clear me how to connect to my database

Answer Question   |  November 15, 2005  3:44 AM
Database, DB2, Oracle

Effect of DB migration on Interfaces
We are in the process of moving our R/3 4.6 system from Informix to DB2. What are the checks needed to ensure that the interfaces perform as expected. Thanks

Answer Question   |  November 13, 2005  3:33 PM
Basis, Database, DB2, Oracle, Upgrades / implementations

sql query
what is the query to find which user is executing what sql statement

Answer Question   |  November 15, 2005  1:09 AM
Database, DB2, Oracle

Connecting to the Database
I am trying to connect my project in Visual C++ 6.0 to the database in Microsoft Access 2003 using DAO but am receiving an error message stating that ‘unrecognised database format’, how can I do it then?

Answer Question   |  November 10, 2005  3:33 AM
Automated, Data analysis, Database, DataCenter, DB2, DB2 Universal Database, Development, Oracle, Software Quality Assurance, Software testing, Software testing tools, SQL

To add a column to an oracle(8i) table someplace other than the end of the list?
Greetings, Is there a way to add a column to an oracle(8i) table someplace other than the end of the list? Thank you very much, Paula Chen

Answer Question   |  November 9, 2005  8:22 AM
Oracle, SQL

installation of oracle8i
i installed oracle8i in my system.when i put username:scott password:tiger It won’t work i don’t know what is the reason for it.so please tell me how to install or mount the oracle8i? Thank you saravanakumar

Answer Question   |  November 18, 2005  2:00 AM
Oracle

Java and Oracle
hi Sir, I have an application web based. using Oracle backend and Java front end. App server is in weblogic and Solaris os and two cpu with 8 applications. DB server is oracle 8.1.7 on Solaris This application is getting slow when number of threads are more ( like many users login and related activities) [...]

Answer Question   |  November 10, 2005  2:18 AM
Database, DB2, Oracle, SQL