Questions & Answers

  • SQL View performance vs. SELECT

    I am experiencing slow views on my database. If I create a view and run it, then use the same select statement from the view and run. They both return the same data, but View runs slower. My expectations was that since views are compiled, they should run faster. Could some one clarify this for me....

    MHM2815 pointsBadges:
  • Row by Row Stored Procedure in SQL Server 2008 R2

    Hi all, Hopefully someone will be able to help me here - I'm nearly there but can't get it right, I'm trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have a DB with 4 columns (ID, Days,...

    Turdywills65 pointsBadges:
  • How to find a specific word in a SQL table

    How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.

    Boomer15 pointsBadges:
  • Convert spool file to physical file in AS/400

    How to convert result file to physical file?

    Ckishorekumarr25 pointsBadges:
  • How to detect duplicate IP addresses

    How is it possible to detect/locate/discover a duplicate IP address in a network? If this network has a router, does this method of discovery still work?

    NetworkingATE1,545 pointsBadges:
  • What happened to my hyper-visor?

    I installed Windows Phone 8 SDK emulator and received the following error: The Windows Phone Emulator requires Hyper-V. Your PC is missing the following pre-requisites required to run Hyper-V: Windows 8 Professional (64-bit) I’m running Windows 8 Professional (64-bit) OS, a Processor type Intel...

    ITKE342,355 pointsBadges:
  • Using AS/400 SQL to replace a variable string

    I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...

    CharlieBrowne41,370 pointsBadges:
  • How to Test for Numerics in AS/400

    I need to test for Numeric. I have to check, If a variable contains Numeric values. I wanted to use TESTN opcode, but people are saying not to use it; as it does not work properly some times. Is there any other alternative to this? Has anybody done this before? Any help would be of great help....

    svankipu560 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • What’s the better choice: VMware or Virtual PC?

    I've been experimenting lately with some build script (and since I already have ASP.net web part under source control) the script should do that at the end. Grab the "naked" Windows 2003 IIS VMware or Virtual PC image from the networkBoot it upCopy the files from the Build Folder to the...

    ITKE342,355 pointsBadges:
  • Testing VMware Perl SDK with ESXi 5.1

    I’m running a VMware ESXi 5.1 server and I need some help with Perl Scripts. I have downloaded and installed these packages on a Ubuntu 12.04 LTS machine: VMware-vSphere-CLI-5.1.0-780721.x86_64.gz VMware-vSphere-Perl-SDK-5.1.0-780721.x86_64.gz VMware-vSphere-SDK-5.1.0-774886.zip When packages...

    ITKE342,355 pointsBadges:
  • Scope between Solaris 10 & SAN?

    I planned to do Solaris certification but I'm confused now whether to study Solaris 0r SAN?

    Harinagu5 pointsBadges:
  • Why are there two different Citrix image types?

    When I upload files in Citrix, sometimes they are saved as MIME jpeg: image/x-citrix-pjpeg Why is the MIME type different? What is the reason for the difference?

    ITKE342,355 pointsBadges:
  • Webcam breakdown

    When attempting to use web cam on other party's computer, it seems that their computer shuts down. The same occurs when I'm  using mine or other party's. The contact  is between the USA and the Philippines.

    Calamity5 pointsBadges:
  • DHCP client failed to access the Internet.

    I have setup a DHCP server in my company network. Once of my client PC has successful get the IP address. When i type ipconfig /all. This client PC have IP address, gateway. The problem is failed to access the website WHEN TYPNG the URL. At client PC, i can ping the ip address of the website but i...

    david2009575 pointsBadges:
  • DPM audio file is corrupted

    Hello, I use a digital Dictaphone [record format is set to OP-DS2)] for my work which has an SD card. Sometimes when I try to copy & paste or cut file the files to attach to email 1 of the files won't transfer. Please can anyone help? Regards Jim

    dictap5 pointsBadges:
  • Administrator password is forgotten

    If the administrator password is forgotten, how do you log into your computer if the password is a requirement? I remember there being a way to override this step.

    debrajoan5 pointsBadges:
  • Disable all auto formatting

    How do I disable all auto-formatting functions when creating a Word-type document?

    usctex5 pointsBadges:
  • Creating VM copies for temporary use

    Is it possible to copy the VMs located in a data store and put them up on a different server while performing maintenance on the main virtualization server? I’m using Linux, so I don’t think the Converter utility will work.

    ITKE342,355 pointsBadges:
  • How to run a stored procedure directly from a begin- end; statement?

    I have a stored procedure with some dbms_output statements in it , i want to run this stored produre directly from begin end; statement in order to check how it woks...

    hussain22juzer500 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