Questions & Answers

  • InnoDB: Shrink file without having to dump and re-import database

    I'm using InnoDB and it's storing all of my info in one big file. I went in and removed a big table but the file still keeps the same size. Is there a way I can shrink that file without dumping and re-importing my whole database. Thank you very much.

    ITKE405,890 pointsBadges:
  • QSECOFR sign on

    DSPUSRPRF QSECOFR shows Previous sign on 08/01/16 05:34:21 Password verification not valid 0 Days before password expires 0 This suggests that a successful sign on took place but that the password is expired. Can anyone suggest why this is?

    Jonesy5 pointsBadges:
  • UIM menus in AS/400

    AS/400 question: In UIM menu Libraray was hard coded as shown below. :MENUI HELP='menu/option1' OPTION=1 ACTION='CMD ?CPYDLLICD FROMMBR() FROMLIB(BCDLLD3)' ACTION=' TOLIB(BCDLLD3)' ACTION='MBROPT(*REPLACE)' My question is: Without hard code the library (BCDLLD3) in UIM menu, how do I pick the...

    chowas400620 pointsBadges:
  • InnoDB or MyISAM – What is faster?

    This might be a more generic question but I need to know which is faster: InnoDB or MyISAM? Also, does MyISAM need to do disk reads for my data? If so, does that make it slower. Thank you.

    ITKE405,890 pointsBadges:
  • Lowering the volume in a video

    I have a concert video which you can hear me singing in it. I would love to remove my singing from these videos. I recorded the videos on my phone. Is there a way to split the audio on different tracks, lower my voice but keep the sound of the performers?

    NeedHelpAsap5 pointsBadges:
  • Outlook room booking

    I am trying to find a way to prevent other users from being able to book meetings in my conference room. I currently have it set up so only a number of people have access to the room. The problem I am running into is Outlook will not prevent these outside people from setting up these meetings. The...

    sbelhume5 pointsBadges:
  • GXV3175 video calling server

    I would like to set up a business video conferencing, between gxv3175 from one country to another, for example Italy to Canada. The grandstream Engineer told me I need my own server or a SIP that supports video. I need help to make this work. I reside in Canada. Giuseppe

    Giuseppe19685 pointsBadges:
  • Converting .PAD extension files

    I recently purchased multipad files (.PAD extension) to be uploaded to Yamaha PSR-S650 keyboard. However, .PAD extension is not compatible with the keyboard. As per the PSR-S650 manual any one of these files are compatible: registration files (.usr), style files (.sty), song files (.mid), and MDB...

    parmesh5 pointsBadges:
  • We have a virtual environment build up recently and we have started facing IO issues and disk perf. issue

    Virtual servers build recently have 4 cores and 16 GB memory on them need to know what is the best baseline for SQL servers as we have started facing IO issues and disk performance issues. Min CPU requirement Min Memory requirement Disk provisioning  - what is recommended thick or thin

    SQLDBA215 pointsBadges:
  • How reliable is the cloud to store ERP Production Server (Application and/or Database and/or both) with increasing vCPU, vRAM and vDisk Space…

    How reliable is the Cloud to store Manufacturing, Sales and Financial ERP Production Server (Application and/or Database and/or both) with increasing costs on  vCPU, vRAM and vDisk Space requirement each year as well as Internet Charges by 25-50 users to call and save transaction data and generate...

    VijithaIvor10 pointsBadges:
  • Is cloud just a hype and still not ready to replace on-premise Windows Application and SQL Database Small Server?

    Is Cloud just an 'EARLY BIRD' Hype where Cloud and Internet 4G Technology still not ready to replace "On-premise Windows Application and SQL Database Small Server" in terms of Network Bandwidth Speed and Infrastructure Cost - just to fund IT Giant's R&D and Cloud Marketing activities - when...

    VijithaIvor10 pointsBadges:
  • SQL Server 2008: Write SELECT query to CSV file

    For SQL Server 2008, I'm writing a SELECT query results to a CSV file. Can I do this using T-SQL? And I don't have access to SSIS too (I know you can do it there). Someone told me to use BCP utility - would that work? Thank you in advance.

    ITKE405,890 pointsBadges:
  • Set password in Outlook 2010 for sending emails

    Hi, Can anyone tell me, how I can set a password to prompt me for password when I send a mail and Outlook 2010 sends the message only after providing the right password?

    clark445kent8,210 pointsBadges:
  • Recover Windows 10 password

    I forgot my password to get into my laptop. It's running Windows 10 and I don't have a reset disk. Can you help me?

    tracy695 pointsBadges:
  • “I/O Error 123”

    "I/O Error 123" This message appears when trying ot run an application (exe). How can I solve it?

    Christossev10 pointsBadges:
  • Opening Lotus Notes .NSF files

    Hi, I left a job a while ago where we used Lotus Notes. I took copies of my NSF files, (current mail file and archive files for each year), and am now trying to get into them to dig up some old emails. I also took a copy of most of the IBM/Lotus/Notes/Data directory, including my ID file. I don't...

    BeeBall25 pointsBadges:
  • How to fix a SQL Server database that’s stuck in a restoring state

    Our department currently has a SharePoint server. But our network administrator mis-configured the backup tool (it was Symantec Backup Exec) and several of our SQL Server databases are stuck in restoring state. What should we do? Can we get these databases back?

    ITKE405,890 pointsBadges:
  • Compatibility between HP and Lenovo hard drives

    Is a HP desktop hard drive compatible to a Lenovo desktop hard drive?

    tomchap5 pointsBadges:
  • Oracle: Track changes that are made to database

    In Oracle, how can I keep track of changes that are made to my database? This would include: Objects, packages, etc. Should I use a trigger? Or some other software?

    ITKE405,890 pointsBadges:
  • Restart the load balancing server without disconnecting the active sessions?

    Hello, How do I restart the load balancing server without disconnecting the active sessions? Thank you!

    harrythomas260 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