Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:
  • Sequence information of mutltiple subforms in one form?

    I have one form embedded 3 subforms. I need to identify which subform is the top of the form because I need to write out the fields value to CSV in subsequently left top to right bottom as user can see on their PC.

    koseiarai5 pointsBadges:
  • Creating an Access 2007 query with results similiar to a Crosstab query

    I am new to Access and I have an Access 2007 database that has a table that has the following fields: Employee Name, Date Worked, Yes/No for Paperwork Received and Yes/No for Paperwork Returned. Is it possible to create a query that I can run a report off of that will show one row for each...

    mjp126215 pointsBadges:
  • CPYFRMIMPF – CSV to flat file. Getting all blank records.

    All records in the flat file are blank when performing a cpyfrmimpf. Copy file command is listed below. DTAFMT is *DLM, FLDDLM is ',' A sample from the file in IFS is listed below. What am I missing. CCSID of file in IFS is 1252. CPYFRMIMPF FROMSTMF('/ITG/OGAZIP/districtzip.csv')...

    dpitts4619495 pointsBadges:
  • Corrupted log file on Exchange still needs to be restored.

    How would you recover Exchange server when the log file is corrupted?

    Karl Gechlik9,860 pointsBadges:
  • conversion problem

    how do you convert DCF files into CSV files for export to Excel Spreadsheet

    ironpony45 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:
  • Errors creating database with SQL Server 2008 I&M Training Manual

    I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),...

    Howhighthemoon20 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:
  • How to match CSV field values in SQL Server 2005

    i have an table in sql-server 2005, in which my one field is storing csv values.Suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in csv format. now my problem...

    Sanjeevgoyal5 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...

    ITKE346,360 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 to convert SQL Server 2008 R2 BPA output into CSV?

    I have been using SQL server 2018 R2 BPA for getting data from Microsoft. When using SQL Server 2005 to export results I could do so in a CSV format. When we upgraded two servers to Server 2008 I found that I could no longer run BPA 2005 on these. We then upgraded to 2008 R2, which again does not...

    ITKE346,360 pointsBadges:
  • Script to extract files information from FTP server

    Hi, I wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will: Log on to a ftp server using a generic account and password It then find the files (no downloading) in a specific folder that begins with...

    Aiko2720 pointsBadges:
  • Import AD data from CSV file to 2003 ad

    We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.

    Karl Gechlik9,860 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:
  • Collation

    What is simple definition and example of collation?

    Raviknowledge5 pointsBadges:
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 pointsBadges:

Browse Alphabetically:

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