Questions & Answers

  • SSIS Server Maintenance running 2 days

    My internal.operations table in the ssis db has over 600,000 rows. Before doing enough research, I changed the retention window and allowed the maintenance job to execute. The job is deleting approximately 10 records every 20 minutes. I want to stop the job; however, I'm afraid of what will happen....

    kmccourt03195 pointsBadges:
  • Query/400: Subtract one date from another

    I only want my calculate to use number of business days.

    queryhelpserena85 pointsBadges:
  • Unable to remote connect to MySQL server

    I can't figure this out for the life of me but I'm not able to connect remotely to my MySQL server. This is the error I'm getting: ERROR 1045 (28000): Access denied for user So what am I doing wrong? Can someone help me?

    ITKE440,550 pointsBadges:
  • How to get list of MySQL database constraints

    Would I be able to get my list of constraints from my MySQL database? What SQL query should I use? Thank you so much.

    ITKE440,550 pointsBadges:
  • How to import MySQL database dump to SQL Server

    I currently have a SQL file that's from a MySQL dump. It contains a bunch of things including: Tables, definitions and all the data. Is there a way to convert all of this to a SQL Server database?

    ITKE440,550 pointsBadges:
  • How to find total number of columns in MySQL table

    I'm looking to find the total number of columns in a MySQL table. Would the code below work or do I need something else? select count(*) from tablename Thanks!

    ITKE440,550 pointsBadges:
  • Maximum length of MySQL table name

    I have a straight to the point question that I'm confused about. In MySQL, what's the maximum length for a table name? I read it might be 64 characters but I want to make sure. Thank you.

    ITKE440,550 pointsBadges:
  • Best way to copy a MySQL table

    Does anyone happen to know the fastest / best way to copy a MySQL table? I created this code below but not sure if it will work: CREATE TABLE copy LIKE original; INSERT INTO copy SELECT * FROM original; Also - would the indexes be re-created? That's my primary concern. Thank you.

    ITKE440,550 pointsBadges:
  • How to duplicate MySQL table

    I'm trying to duplicate a MySQL table - but the new table has to be empty. After that, then I have to copy the data structure from the existing table to the new one. How can I go about doing that?

    ITKE440,550 pointsBadges:
  • How do I open CCA files?

    How can I open CCA files?

    ProfMichaelK5 pointsBadges:
  • Unable to log into Outlook

    I am currently unable to log into my outlook-pop-up. It says someone else may be using it.

    Jessie15 pointsBadges:
  • Download YouTube video

    How can I download a video from YouTube

    sdfgbsg5 pointsBadges:
  • My smartphone won’t turn on

    My telefunken phone can not turn on. What should I do?

    cedarali15 pointsBadges:
  • When does MySQL database view get updated?

    I currently have this view in MySQL: CREATE VIEW blah AS SELECT columnA FROM tableA But I need to see this specific view gets updated. How can I see that? Appreciate the help.

    ITKE440,550 pointsBadges:
  • Convert MySQL string to date

    I have a MySQL string column that is currently acting as a date and I have to select it as a date too. How can I do that? In simplier terms - I need to convert it over to a date.

    ITKE440,550 pointsBadges:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • How to delete Ubuntu

    How can I go about deleting Ubuntu from my system?

    Ashirbad5 pointsBadges:
  • Should the design cycle of new products include an analysis of security vulnerabilities?

    Black Hat 2013 was a tension filled affair. In addition to National Security Agency Director General Keith B. Alexander defending U.S. surveillance of American citizens, claiming it's a necessity in a world threatened by what he called "terrorists among us," SeungJin "Beist" Lee showed attendees...

    Chris Leonard4,300 pointsBadges:
  • Updating MySQL column with NULL value

    In MySQL, is it possible to update a column with a NULL value. I tried several different times and all I have gotten is an empty string. Do I have to use a syntax?

    ITKE440,550 pointsBadges:
  • Merging two MySQL tables

    I need to merge two different MySQL tables (that have the same data structure). The biggest difference is that the primary keys are different on each table. What's the process here?

    ITKE440,550 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.