• Copy a file of 20 million records to another file.

    Hi Group,I need a copy data from a file having 20 million records to another file. What could be best way to achieve this? One way is creating a duplicate object. Is there any other method?Regards,M

    mvrkrishna525 pointsBadges:
  • Single Page Subfile

    Hi.. I need to create a window subfile in RPGLE, and the subfile field values should be taken from the array which is defined in program itself. Can anybody give me the sample code for this? Surey

    Sureyz2,300 pointsBadges:
  • How to clone a table in SQL Server Express 2012?

    I’ve built a SQL Server table with several columns with an index starting from 1 as the primary key. I need to clone this table but without the data and with a different index starting from 100. I don’t know how to do this. I am using SQL Server 2012 Express that came with Visual Studio 2012.

    ITKE54,865 pointsBadges:
  • Database all about RAID introduction including annotated diagrams

    Can someone help me with this question: RAID Levels, Hardware issues,choice of RAID level and improvement in performance via parallelism

    cos5 pointsBadges:
  • Undefined report

    Why would an undefine report attached itself to the bottom of a report that is defined?

    CAADMIN5 pointsBadges:
  • Mount Windows Partition in Ubuntu

    I installed Ubuntu onto a WinXPP machine so that they are duo boot. The system should have automatically mounted my windows directory and created an icon on the desktop. It did not. I followed the directions and opened a bash shell and typed sudo vol_id -u /dev/sda1 Ubuntu returns the error command...

    Hsmithdp125 pointsBadges:
  • San Mount Volume Changed HELP!!!

    I run a system comprised of 36 IBM Blade servers, a Hitachi 64TB SAN, a Data Domain backup suite and connection devices. I run Windows 2003 R2 (32bit) and Red Hat 4 (64bit). I have just come across a problem in that all the windows blades in one (of three) chassis are displaying my drive E: (which...

    GMB8635 pointsBadges:
  • Creating a trigger in SQL Server 2008 R2

    I have three tables in SQL Server 2008 and they all have the PK-FK-FK-relationship. 1st table: I have a column name with the name as "STATUS" that contains the value "active" or "inactive". 2nd table: I have the column with the name FKNEWLoanReviewfieldid, which has multiple values 3rd table: The...

    ITKE54,865 pointsBadges:
  • Best way to manage tables in SQL Server 2012?

    I have a table that captures about 100,000 records per day. As you can imagine, the size and performance of such a table would degrade as it quickly went well over 50 million records. I want to try something different, and that is the creation of a new table every day, so that the number of records...

    ITKE54,865 pointsBadges:
  • Incompatibility issues between SQL Server 2012 and Visual Studio 2012

    I am hitting a strange error while trying to create an SQL Database project in Visual Studio 2012. Unable to open Database Project This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer. I am using SQL Server 2012 Developers Edition...

    ITKE54,865 pointsBadges:
  • Using bulk delete on SQL Server 2008

    Looking for a way to "Bulk delete" in SQL Server 2008. Since I want to use WHERE for limiting the rows in action, I know I can't use TRUNCATE. Should I use something like "batch deletes" or "bulk copy"?

    ITKE54,865 pointsBadges:
  • Rolling back updates in SQL Server 2014

    Is there anything that will allow to rollback and UPDATE query in SQL Server 2014 that was not available in previous versions? I’m referring to committed commands – I know you can rollback if query is inside transaction. We have full, differential and transaction log backups in place but we’d...

    ITKE54,865 pointsBadges:
  • Windows 7 is very slow to start from hibernation

    For the past few weeks, my Windows 7 64-bit ultimate machine has been extremely slow to restore from hibernation. It spends several minutes on a blank screen with a blinking cursor. After it starts, it takes forever to get any of my programs to load. I've tried to the following things to speed it...

    ITKE54,865 pointsBadges:
  • Merging columns in SQL Server database

    Hi everyone! In my SQL Server database, I'm trying to merge the following: [TicketID], [Person] T0001 Alice T0001 Bob T0002 Catherine T0002 Doug T0003 Elaine Into this: [TicketID], [People] T0001 Alice, Bob T0002 Catherine, Doug T0003 Elaine Now, I know there's the function "GROUP_CONCAT" for MySQL...

    ITKE54,865 pointsBadges:
  • Migrating from an AS/400

    What should I bring up to someone when I am trying to get them to migrate from an AS/400? What are the pros and cons of migrating from the AS/400?

    Cgoodin20 pointsBadges:
  • Comments missing after copying

    Hi all, We have a common source physical file QRPGLESRC in lib Qbbb  for our Project. In this, almost all RPG Members are having comments for understanding the program. Well, when I have a copy to my own Source file Qxxx in another Library Qyyy to change the program according to new requirement,...

    Sai4AS4001,420 pointsBadges:
  • Cache-based side channel attacks

    Please help me find a new secure mechanism against cache based side channel attacks in the cloud. I found that ieee published a method for security against AES, RSA, BTB attacks to retrieve the secret key. It is architect based method. Can I do any modification to this work after implementing this...

    mvidya199020 pointsBadges:
  • Secondary storage for the future

    Does anyone have some examples of advancement in secondary storage for the future?

    winsonloseson5 pointsBadges:
  • Remote connection error using SQL Server Express 2012

    Now, I've recently added SQL Server Express 2012 to my home server. I'm trying to connect to it from Visual Studio 2012 from my machine but I keep getting this error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was...

    ITKE54,865 pointsBadges:
  • Email Trigger failing in SQL Server 2012

    I'm having trouble getting a trigger to work.No errors are being thrown, but nothing is being email either. Is it my nested select? Use ABCTRAINING SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter TRIGGER TAXPERCENT ON [dbo].[AP101_VOUCHER_DISTR] AFTER update AS declare @VAT numeric(15,2),...

    ITKE54,865 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