• T-shirt giveaway: Have you uploaded your profile pic yet?

    I'm noticing that some of our users who are active on the site still haven't uploaded a profile image! Remember -- having an image uploaded not only shows other users who you are; having a full profile with an avatar also makes us more likely to choose you as a "Member of the Week" or "Featured...

    JennyMack4,280 pointsBadges:
  • Select – Top 10

    Hello, I have to tables, one with name CONTRACT, second AGENT IN table CONTRACT these data: ClientID ClientName ClientSurname ContractNR AgentID AGENT data: ClientID Sum ContractNR I need to select 10 agent's clients, who have a bigest sum. One agent have 100 clients, second only 2 or one client....

    Svetlaneto5 pointsBadges:
  • Auto backup configuration in SQL2005

    How to setup an autobackup for the backup type of Full database and transaction log together as a single bakup file in sql2005.? We can setup to backup full database seperately and transaction log seperately, but i wanted these two should be a single backup file. Any suggestion pls.

    Shamoh40 pointsBadges:
  • Access 2003: Can’t filter Part-no’s by highest $Spend Plant/Site

    I have a file of Part-no with the spend by Plant (or Location).  A given Part-no may have multiple records for the different Plant Locations. I am trying to capture one record for each Part-no that included the Plant with the highest spend and what that amount is. I tried to do a summary query...

    GatorRobNC5 pointsBadges:
  • MS Exchange on Server 2000 one user can receive but not send mail

    One of my users reported that he is not able to send e-mail from his Outlook client.  I sent test messages from his Outlook client to both an internal and external address and did not receive eitehr message.  I sent him e-mail from both my internal and external e-mail addresses and they went...

    Mryansimonovich30 pointsBadges:
  • SQL 2005 will not recognize other local disks

    SQL Server Management Studio only recognizes one drive on the server, how do I get it to recognize the other Local disks?  The one disk it does see is also on the AX-100, but it will not list any of the others, even the interanl disk, as options for devices to create databases on or for backup...

    Rick2766225 pointsBadges:
  • CCSID in AS400

    Hi, i am trying to update a DBCS data defined through ODW BPCS version 6 to DB400 and i run into error SQL-332.I do not whether the problem is with the host variable.I find all the definition of variable being handled properly. Thanks, karthick

    Karthick0835 pointsBadges:
  • About Time

    Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet  

    Checkp310 pointsBadges:
  • Windows Server 2003

    i have a sever 2 G.B ram ,prosser Intel Xeon 3.0Ghz, i want to configare a domain controllar with using sql application server on that server i want to configare it domain along with sql application server . IS this configaration enough for both server or i needed to  improve configration ....

    Bbb845 pointsBadges:
  • Database restore

    I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in time,...

    Thedbaed5 pointsBadges:
  • Techniques for storing SQL Server data online and for backing up the server

    For a banking application, I would like to keep 10 years worth of data using SQL Server. I would like to keep two years online and backup the other eight years. What are some techniques to do this?  

    SQL Server Ask the Experts2,585 pointsBadges:
  • Reducing SQL Server backup and restore time

    Our database is big (about 320 GB) and it takes some time to backup and restore. The client wants us to suggest techniques that would reduce the time. I have tried "piecemeal" restoring, which allows you to backup and restore individual filegroups in the database. It works fine with all the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • MySQL database size

    Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance?

    Worktopm5 pointsBadges:
  • Conversion of SQL Server 2000 to iSeries DB2 V6R1

    Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.

    Tprusko5 pointsBadges:
  • Auditing Windows 2003 and MS SQL 2005

    Are there any audit scripts I can use to audit Windows 2003 and MS SQL 2005?

    Gideont5 pointsBadges:
  • Set identity to not for replication in T-SQL

    Hi, Does anyone know the TSQL to change the identity column on a table in SQL Server 2000. And also the TSQL to change trigger to not for replication. Thanks

    Db23290 pointsBadges:
  • Is having the auto create statistics on in a database a good thing?

    Hello I have a 250GB database and the auto create statistics is on is that a good thing?

    Rick Martinez585 pointsBadges:
  • Replication sync_method set to concurrent in SQL Server 2000

    Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been...

    Db23290 pointsBadges:
  • How to create a maintenance plan in SQL Server Management Studio Express

    I’m running SQL Server 2005 Workgroup edition with SP2. I’m trying to create a new Maintenance Plan in Microsoft SQL Server Management Studio Express (MSSMSE) by right clicking on the Maintenance Plans object icon. The only option is Refresh - there’s no manual method or wizard. I'm logging...

    SQL Server Ask the Experts2,585 pointsBadges:
  • The most-watched IT questions this week: Oct. 20, 2009

    Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

    Michael Morisy8,038 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