Database Tag Directory

Featured Database Questions

  • Should I use MEDIUMBLOB to store large files in MySQL database?

    I need to store user uploaded files to our database (and I can't use a file system). The files are all different types and I'm running into a problem deciding if I should use "MEDIUMBLOB" to store these as binary data. And this problem arises from the files having various file sizes. I understand I...

    ITKE332,130 pointsBadges:
  • Clustered index in SQL Server 2012

    A clustered index is created automatically in SQLserver 2012 while creating a table with primary key. The index is created on the primary key field. My queries which are not using the primary key for search are costing 100% on clustered index scan. Should I create covered index for each and every...

    dhanam115 pointsBadges:
  • Advantages and disadvantages of clustered indexes

    What are the advantages and disadvantages of clustered indexes?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Bulk update in SQL Server 2005

    I need to update Column A1, Column A2 data in table A with Column B1, Column B2 data in table B for over 100,000 rows. How do I write a procedure to accomplish this in SQL Server 2005?

    Rl10 pointsBadges:
  • SQL Server 2008 R2: User table with clustered indexes

    I recently found that a couple of my tables in SQL Server 2008 R2 with no clustered indexes defined. However, there are non-clustered indexes defined (so basically they're on HEAP). After I did some searching, I learned that some select statements were using a filter on the columns defined (in...

    ITKE332,130 pointsBadges:
  • bulk update in sql server 2005

    hi.. i have tried UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3 this query but it is not working.. plz any one suggest me.. thx in advance...

    MinteeLoki5 pointsBadges:
  • How do I create an OEM-style bootable recovery partition?

    Very simple question, but not so simple of an answer. I would like to create a hidden recovery partition on all of my companies laptops so that if/when it gets destroyed in the field, when the user boots up, they insert a cd that says, basically "press 1 to restore your system to factory defaults"...

    swinehart68031,050 pointsBadges:
  • BULK COLLECT and FORALL in PL/SQL

    How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.

    RangjungDorje20 pointsBadges:
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • CGIConvMode BINARY – Help, I cannot make it working.

    In the CGI, I use iconv() to translate all input/output from ebcdic to utf-8 (ccsid 1208) and vice versa for the body. For the CGI output Header I don't process any translation, add x'15 twice to make a blank line. (as the HTTP default should make the translation from 37 to 819 for the http header)...

    PascalP20 pointsBadges:
  • MS-Access data inserted in to Oracle 11g CLOB

    I have an old MS-Access database storing data in bullet point format. I need to transfer this data across to an Oracle 11g EE database version at the same time maintain the MS-Access formatting.  How do I go about this?

    Sgafair5 pointsBadges:
  • Cloning C and G drives on Windows Server 2008

    I need to clone my C drive and G drive on a Windows server 2008. The C drive is a mirror and the G drive is a 6 disk raid 5. What is my best option for cloning this setup?

    TeachMeIT975 pointsBadges:
  • Numeric or Value Error for string aggregation

    Hi, I use below code for string aggregation. My database table which I apply string aggregation is a large one with 165 million rows. Although I use CLOB, I get numeric or value error in eggregation termination function after the script is run for a long time. For a small table, I do not get this...

    Mitilma5 pointsBadges:
  • Domino Geo Clustering

    Does anyone know or can anyone point me to docs on Domino Geo Clustering? More specifically, I'm trying to find out what the recommended (best practices) pipe would be between the two. I realize there are some x factors involved as well but I'm just looking for anything put out by IBM.

    Petetm800 pointsBadges:
  • Receiving a Binary file

    I have a vendor who is placing a files on a FTP Server in Binary.  I need to retrieve those files and place them into an iSeries database file. Is there away to retrieve the file straight from the FTP Server into the database file using GET that will translate from binary to mixed text and packed...

    AS400PCFileTransfer16115 pointsBadges:
  • Cloning my dual boot Ubuntu/Mac PC to another

    HI, I have some computers which dual boots Ubuntu and Mac. I need to do the same in around 20 PC`s again !!! How can i do using less resources and time ?? (All PC`s are of the same configuration) (all computers can be connected via LAN) (I think Norton Ghost is not a solution .. !!)

    Jibin405 pointsBadges:
  • Cloning existing database servers to migrate to virtual machine

    Can we clone existing database servers with their contents and migrate to a virtual machine? We want to do this for two smaller database servers that are each on very expensive high level machines. One can be repurposed and the other can support both servers as vms.

    NewnanIT1,110 pointsBadges:
  • How to convert LONG to CLOB or to VARCHAR type in select statement

    Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...

    SamG15 pointsBadges:
  • Building a replica of production ERP boxes

    We want to build a replica of our production ERP boxes. How can we clone the entire system including the raid configuration and all drives connected to the system?

    ITKE332,130 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