• 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:
  • 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:
  • 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,323 pointsBadges:
  • STORED PROCEDURE

    Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it  

    AS400SQL25 pointsBadges:
  • SQL related tables

    I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from...

    Geeko5 pointsBadges:
  • Different database & server collation

    Hi, We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without running...

    Db23290 pointsBadges:
  • ms sql query problem with a case statement

    [strong]This code works: SELECT     passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...

    Rinkratt20 pointsBadges:
  • SQL Server 2005 distribution agent failed

    Getting this error message

    ITKE351,905 pointsBadges:
  • Most popular blog posts this week

    10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...

    ITKE351,905 pointsBadges:
  • Tree View Control

    i am trying 2 make and explorer using the tree view control in my project using VB 6, SQL Server 2000 and crystal reports. in the looping statements i had inculed the details and all. i need 2 display the results in the Grid Box when click the nodes in the Tree control. please provide the code for...

    RAYNISH35 pointsBadges:
  • Restore a View Sql Server 2005

    I over-wrote a VIEW by mistake. How do I recover the original version of the view? Is there a way to ROLLBACK a "CREATE VIEW..." command?

    VelameLaCosa110 pointsBadges:
  • The most-watched IT questions this week: Oct. 13, 2009

    Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. 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. Going green: Are you feeling...

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