• Performance of very large SQL Server table with millions of rows

    Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it Bigtable) - Any data...

    Elhajjh5 pointsBadges:
  • How to find a string in all columns of a table

    I want to search for a string for example "POLARIS" in all the columns of a table ? How to find the string using sql query ?

    Dhumane5 pointsBadges:
  • Embedded SQL over multiple physical file members

    Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have the...

    Gilly40023,730 pointsBadges:
  • error in connection between oracle8i&developer2000

    I'm installing Oracle8i on Windows 2000 professional on NTFS partition and on the same machine I'm installing Developer 2000 or form6 in a different partition. When I try to connect Developer to Oracle, I get the error "TNS could not resolve." Please provide a solution. Can I use Oracle8i...

    POWERINIT0 pointsBadges:
  • Single “Filler” Field Flat File vs Multiple Fields Defined Flat File

    What are the Pros and Cons of using a Flat File with a single large field defined compared to a Flat file with multiple defined fields? For example: Physical File: TESTFILE1 R TESTFILE FIELDA 50 Physical File: TESTFILE2 R TESTFILE DEFINED1 20 DEFINED2 10 DEFINED3 5 DEFINED4 15

    AWDSYSMGR20 pointsBadges:
  • Configuring a SQL Server to optimize for best performance

    We are running SQL Server 2005 on Windows Server 2003 R2 Enterprise Edition x64 SP2. These are Dell 2950 servers with 16 GB of RAM, and they are dedicated to SQL Server. We are mainly performing large database migrations utilizing SSMA and ODBC from Sybase. How can we configure Windows and/or SQL...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sending a message from Access thru Lotus

    Error message comes up: "A stored from can not contain computed subform" and my message comes out unformated on Lotus 6.5 but it is fine on 8.0 (or is that really the reason?) All our users are on 6.5, what do I do to fix this?

    Ricard5 pointsBadges:
  • Oracle archives are not moving from primary to standby database

    Archives are not moving from primary to standby database, which are in the same machine. What things do I need to check?

    OracleATE190 pointsBadges:
  • ADO connection fails after upgrading from Oracle 10g to Oracle 11g

    I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property 'SERVER' returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

    OracleATE190 pointsBadges:
  • Looking for Antivirus for Win Storage 2003 x64 server

    Hi, We are looking for an antivirus software that proven to work well with windows storage 2003 x64 server. Our current product works just fine on all other 2003 servers, but it brings down this one from time to time. Thanks, Oksana

    Oksana0 pointsBadges:
  • DBA:DB ratio

    Test, but useful, question: How many DBAs and databases do you have at your organization? We have 160 oracle databases, across 105 servers, supported by 4 dbas. (We actually have more databases, but some are not supported by the Oracle DBAs.) Thanks, Carolyn

    Catalysttx0 pointsBadges:
  • Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)

    CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); PROCEDURE tab1_statement_change; END trigger_api; / CREATE OR REPLACE PACKAGE BODY trigger_api AS TYPE t_change_rec is record (...

    APB10 pointsBadges:
  • Crystal Reports OBDC (Oracle)

    I created an OBDC on the client to link into the Oracle server, and using it in Crystal report, I can only see the system tables, but not the database table. Using the same obdc in Access application, I can see and am able to link all the tables. Do anyone know why is that I can't see the database...

    Askme5 pointsBadges:
  • What are the most overused tech buzzwords for 2008?

    I'm the editor for whatis.com and I'm trying to put together a list of the most overused tech buzzwords for 2009. Can you help? Cloud is #1 on my list (and all its variations). Green will be on the list too. What else belongs on the list?

    Margaret Rouse1,220 pointsBadges:
  • delete from flat file

    HI My flat file contains data copied from a spool file.The records in this file is used as reference to delete links from dir.Can i delete those records in the flat file for which there is no link in the dir(that is the link or text file object has been deleted from the dir) ?I tried using embedded...

    0 pointsBadges:
  • Access 2007 – How to include option group on report

    Hello, I'm new to Access so please consider this when forming your response. This has been driving me crazy and I've looked high and low on the 'net for a solution. I look forward to your response. I have a form with an option group. I've wish to have this display on my report. Take for instance...

    Tuxalot5 pointsBadges:
  • Notes rich text field to BLOB/Memo field in SQL Server using ADOdb

    I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I'm finding examples of reading this kind of data back into a Notes...

    tjarman90 pointsBadges:
  • AS/400 to SQL Server 2008

    Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I may be missing in regards to the link to...

    Rmason335 pointsBadges:
  • ODBC on Linux

    A user on Twitter, @garyvee, has a question for the community: Whats the best solution for ODBC on Linux ? And is anyone actively working with it? The direct link to his question is here.

    JennyMack4,280 pointsBadges:
  • Monthly Average in Access 2007

    Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible - my VB sucks Thanks Riaan

    Riaane65 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following