• Finding which columns contain data in a table

    I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table 1 has Columns Col1, Col2, Col4 being...

    TedGiles5 pointsBadges:
  • Data QUEUE – Remote location ….. for program device DDMDEVICE was not found

    When trying to use a remote DATA QUEUE the send and receive data queue commands failed giving : Service with protocol tcp not found. Cannot establish DDM connection with remote system. Operation on DDM data queue DTAQFIFO in TESTLIB failed. Remote location MYAS400 for program device DDMDEVICE was...

    SBCHenry30 pointsBadges:
  • SQL SERVEUR 2005 SISS AND WHERE statement

    I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

    Sqlbeg5 pointsBadges:
  • ExcelSource file – metadata validation

    I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns...

    Mayre5 pointsBadges:
  • How to enable a trace for SQL Server Analysis Services using T-SQL?

    Hi I want to enable a trace on analysis services Filter only the errors and notifications log them in a table and send a mail. I am right now doing using sql profiler, but i dont want to do this using profiler as i have to log on the server continuously. I need to do this in T-sql like an SP or a...

    GIG240 pointsBadges:
  • Data center analytics question

    What is the future of the data center analytics market? Where can I get market trend data with sizing? Any help here is greatly appreciated. The blueprint attached is quite interesting

    Biligiri5 pointsBadges:
  • Data Area in CL?

    How to get data from Data Area using CL program code?

    6r1,850 pointsBadges:
  • Replicating SAN to DR Site

    We are looking to build a warm DR site across town. How are other companies managing to duplicate their data in a reasonable time to another location? We are looking to copy around 150 GB per day. We don't need up to the minute data, up to the hour or two is acceptable.

    Mpweber20 pointsBadges:
  • How do I prove that a full backup of Fi-Co when restored onto another system is a true and good copy of the source system.

    Hi, during a change freeze and after a full offline backup I am restoring this backup of my current production Fi-Co system onto another server to act as a system reference before making major changes to my live production system. My question is how do I prove to my business colleagues that the...

    Atalanto5 pointsBadges:
  • Converting SQL data to Microsoft Access through coding in VB.NET

    I have tables in SQL and i want to port them to MS access through coding in VB.NET

    Kiti15 pointsBadges:
  • What is the difference between Hitachi ShadowImage, Hitachi TrueCopy and Universal Replicator?

    What is the difference between Hitachi Shadow image, Hitachi True copy and Universal Replicator? What are the best scenarios where each of them can be implemented?

    SearchStorageATE215 pointsBadges:
  • SQL Queries

    pls any one help me I Need to disply in o/p only alphabets but not any numbers or integers for this i/p as follows i/p o/p ----- ---------- 1.2NE NE 1.1NN NN 1.3.1NE NE 1.1CE CE 1.2.2NN NN 1.6.2NN NN 1.3CE CE 1.3CE CE 1.1 --- 2 ---- 11 -- THANKS IN ADVANCE SURENDRA

    Ecsbc35 pointsBadges:
  • Macs and SPSS 17

    Which mac would be best to use for statistical analysis using SPSS? I know that most PCs make this easy with WIndow and MS Access as db, but I have a house and office filled with Macs - only other option is to add a PC. Thanks!

    StatsMan5 pointsBadges:
  • Write Lotus Notes records from a Lotus Notes database to a DataMart in Oracle

    I'm new to LEI and I need to write Lotus Notes records from a Lotus Notes database to a DataMart in Oracle. Does anyone know where I should start on this, or if possible can anyone provide a code snippet? Thank you in advance.

    Domino Ask The Experts435 pointsBadges:
  • How widespread is de-duplication in your data center?

    How widespread is de-duplication in your data center? Backup/archive de-dupe? Integrated into every file server? Being considered but not yet implemented?

    DellStorage30 pointsBadges:
  • How to order a list?

    i have a list from a text file in this format: Wence Rollins Hernandez Perry Rollins Dai Holzapfel Hernandez Perry Stelzer Adhikari Darrow Heafey Harmon Dai Steenbock Darrow Bell Steenbock Adhikari Bell Holzapfel Stelzer Heafey i have to put in in a format like this: Wence, Rollins, Dai, Steenbock,...

    Adhikarisubodh5 pointsBadges:
  • Data Migration using LSMW

    I would like to know whether it is neccessary, to go through recording process when migration GL account codes from Legacy to sap using LSMW, I know you have to go through Recording if you are migrating Vendors or Customers Master data. Any ideas?

    Mrt200815 pointsBadges:
  • SSIS package using dynamic configurations

    Hi I have to create a package which process the analysis services cube and its partitions,and dimensions. This package should run every 15 minutes to process the cube. I have a procedure which creates the database in analysis services db and relational db for the current month. I have another...

    GIG240 pointsBadges:
  • SQL View on 1 AS/400 using data from another AS/400

    We have 2 AS400 machines connected with a 1g pipe. I need to create a SQL view on one of the machines using data that is in DDS physical files on the other machine. How can I accomplish this?

    Oldtonew135 pointsBadges:
  • Do 10Gbit iSCSI and 8Gbit FC change how you think about your strategy for managing your data in the future?

    Do 10Gbit iSCSI and 8Gbit FC change how you think about this and your strategy for managing your data in the future?

    ITKE1,047,840 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.

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

Following