Questions & Answers

  • Changing storage engine in phpMyAdmin

    For my applications, I always use InnoDB. But sometimes, I forget to change it when I'm setting up a table so phpMyAdmin gives me MyISAM. Can I change the storage engine? Thanks.

    ITKE407,655 pointsBadges:
  • Restore SQL Server .BAK file and shrink log size at the same time

    I currently have a .BAK file that was sent to us by one of our clients and this was because of an issue the file is having. Our backup is 25 GB and the database is roughly the same size but it actually needs 100 GB to be restored. We think that the database has a 75 GB transaction log size. Can we...

    ITKE407,655 pointsBadges:
  • Email

    After in email, can not do the some thing in this email.

    skufcal5 pointsBadges:
  • 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.

    ITKE407,655 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.

    ITKE407,655 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.

    ITKE407,655 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,235 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?

    ITKE407,655 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