• What does it mean tail +4 in Sybase

    dblist=isql -S SYBASE1503 -Usa -P << endit | tail +4 use master go set nocount on go select name from sysdatabases go exit endit echo $dblist for db in $dblist do ddlgen -Usa -P -Sabcd157 -D $db -TDB -F% -O $db.definitions.out done As in the above script I'm not getting the that what tail +4...

    pankaj161115 pointsBadges:
  • Generate a database schema level diagram like ERD for MM module in SAP

    How can I generate a database schema level ERD diagram? This diagram will show relationships between all tables in a schema like MM schema.

    gram7720 pointsBadges:
  • Sybase ASE engine

    What is Sybase ASE engine concept? How it actually works? How it is related with CPU core's?

    kaustubh055 pointsBadges:
  • How to use a SQL Server 2008 database on a NAS

    We've been working on a project using Visual Studio. We need to create a local database file with our project directory so we can check into a SubVersion and have configuration management. But we keep getting an error when trying to create or attach a database on a network share. Just to clarify,...

    ITKE366,930 pointsBadges:
  • Reading a file twice in CL

    I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?

    Kumari0 pointsBadges:
  • How to open dbf file?

    I am trying to load DBF files into SQL server within CLR (actually if just running the select statement outside, say within the SQLQuery window, i got the same result), but with the following error: Msg 7314, Level 16, State 1, Line 1 The OLE DB provider "VFPOLEDB" for linked server "MYDBF" does...

    eskilddam5 pointsBadges:
  • Database how to connect OpenOffice base to Visual Basic

    How do I connect OpenOffice base to Visual Basic?

    Learn5 pointsBadges:
  • What is an example of RDBMS software?

    example of rdbms software

    sayyan5 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh40,415 pointsBadges:
  • Is MySQL robust enough for very high traffic websites?

    Just so you have an idea of what I'm asking or looking for as far as database needs , I'm working on a classified ads website gaining a lot of traffic. The database behind it is MySQL. However, my concern is if MYSQL is fit to handle high traffic websites. For example, would a website with 12...

    itguyla5 pointsBadges:
  • Value too Long in Microsoft Access

    this is a hypethetical question.. Using MS Access you enter the last name of a student, and you recieve an error message stating that the value is too long for the field. What are your next steps?

    Jeffhill5 pointsBadges:
  • Converting the XML data into SQL table and how to move values to a CLOB variable.

    Can anybody explain with an example for converting the XML data into SQL table and how to move values to a CLOB variable. Because I've looked at lot of sites but still not getting a proper solution.

    Sasikumarr200 pointsBadges:
  • Stress test a NAS system for a database

    I'm trying to stress test a NAS system for my database. I'm looking to see how much abuse the system can take and how it will affect the database performance. Here's what we have planned so far: Copying very large amounts of Data onto and off of the device (at the same time). Using the SQLIOSim...

    ITKE366,930 pointsBadges:
  • NoSQL Database(s)

    I am knew to this tech. I understand NoSQL is not relational. Could old COBOL file structures or such systems be considered as NoSQL type since we could put different record structures with variable lengths (dependent on array values) and we could design a UI as a record (incorporating arrays as...

    Chegutu465 pointsBadges:
  • Backup and replicate SQL Server database

    We have a SQL Server database that contains our most recent data. We need to replicate the content into several other servers. But for some reason, we can't use the replicate / sync function to sync to other SQL Server instances. What would be the best way to do this? Thank you!

    ITKE366,930 pointsBadges:
  • Clustered index on view

    I've created the view: USE [TorqueNet] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[MY_JOINTS_NUMBER] WITH SCHEMABINDING AS SELECT SPINDLE_GROUP_RESULTS.CONTROLLER,SPINDLE_RESULTS.JOINT_NUMBER,SPINDLE_GROUP_RESULTS.SPINDLE_GROUP, MAX (SPINDLE_GROUP_RESULTS.PROCESS_TIME)...

    debadarshsn5 pointsBadges:
  • Handle MySQL backups with Git

    For our MySQL backup, we came up with a pretty good idea but we're not entirely sure. To backup it up, we thought of putting the dump file into a Git repository, and the commit on each dump so we have the most recent copy / we can roll back to a previous backup. But we're not sure of the flaws...

    ITKE366,930 pointsBadges:
  • How to do MySQL backups on a budget

    Our MySQL backup strategy is to replicate our database to a second server and then run mysqldump on that server to get rid of any downtime from table locking. It's working great but the cost is huge (Over $150 per month on that second server). Anyone know of another way to do MySQL backups cheaper?...

    ITKE366,930 pointsBadges:
  • Setting up a database server in-house

    Goal: add a database server for silo storage environment to meet client requirements. Send queried reports from shared SQL server to new database server to be accessed from website dashboards. What is the best server set up to accomplish this?

    SacredGrounds5 pointsBadges:
  • Best way to backup our production database

    For the past several weeks, we've been looking at CouchDB for a CMS application. What's the best way for us for backing up our production database? Should we possibly clone the database (so we can use it in testing / development). What about just copying the files on a disk? Thanks for the help!

    ITKE366,930 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