• oracle explain plan from yesterday

    Is it possible to see the explain plan used by Oracle for a select statement that was run yesterday?

    Nightoracle5 pointsBadges:
  • SQL Injection in my network

    How can I protect against SQL injections and remove the injection point?  Also, how can I remove an injection that my antivir has detected?  My computer is running extremely slow and I'd like to know what information has been compromised.

    ML35 pointsBadges:
  • SQL REPLACE with pointer

    I need to manipulate xml-files larger than char-field max-length allowed with RPG.   [strong]Background info:[/strong] My current solution uses a char-field... My app stores XML-files in CLOB-fields. I copy the xml-file from CLOB-field to a char-field: I then use %scan to find relative position of...

    DanTheDane2,555 pointsBadges:
  • SQL 2008 query: return results where row not in another table

    hi, running sql2008.  i have the following two temp tables.  the first is just all web service errors for a date range.  the second is simply 20 rows that contain values of types of web service errors. --temp tbl #1 select [date],[err],[srv],[e1],[e2] into #tblExcept from netlog where [err] like...

    RdS1995 pointsBadges:
  • SQL Server Error 7202 Could not find server

    Hi all, I am currently running into the following error when run a stored procedure with BEGIN TRANS:  "Could not find server 'VS-DEVELOPERDEVELOPER_SQL' in sysservers. Execute sp_addlinkedserver to add the server to sysservers." The server shown above is the a local sql server instance that is...

    Jabeam5 pointsBadges:
  • Free IT Book: The Official Ubuntu Book, Sixth Edition

    Take advantage of Ubuntu 11.04, and let The Official Ubuntu Book 6th Ed. get you up and running quickly. To win this essential resource, simply answer one of five questions and post the link to your answer in the discussion section below. PSOD with ESX 3.5 MIMIX replication issue What would you...

    MelanieYarbrough6,345 pointsBadges:
  • Backup started running 2x longer

    Hello, We have a 3573 L2U drive which we are using as a standalone tape drive.  Our backup jobs started running nearly twice longer than our normal run time last week.  IBM SSR replaced the drive, cable and terminator.  However, still after replacing, backup still ran long.  Do you have any...

    IS Questions110 pointsBadges:
  • Converting a command to a Database File

    I was wondering if someone can offer some code or a site that would show some code examples of what I am trying to do on my LPARs. I’ve created a DB file using command CVTWRKSBS so I could create an IBM query over it to see what subsystems are active on the LPAR. However, I want this done on all...

    Rrbond07135 pointsBadges:
  • Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Updating a Date Time Field

    I need to update the Confirmation Date Time field to NULL for a specific meeting but am unsure how to insert it.  The script below works for an individual but if they have more than 1 confirmation date it clears then all. Meet_Master.MEETING is where the meeting code AM2011 is. UPDATE   ORDERS...

    DJandLO130 pointsBadges:
  • Open IT Forum: Did you buy a TouchPad?

    HP's decision to discontinue the TouchPad (and its subsequent steal of a price) has been all the buzz the past couple days. Did you bite at the alluring $99 price tag? Tell us what went into your decision, or if you couldn't care less about the TouchPad. Do you think hackers are about to have a...

    MelanieYarbrough6,345 pointsBadges:
  • Change Initial Program

    how do you change the initial program and library for all user profiles preferrably using SQL.

    Rhinopop15 pointsBadges:
  • Open IT Forum: How do you prepare your data center for severe weather?

    Every season has its share of weather threats, and we want to know how you prepare for them. The east coast is gearing up for Hurricane Irene's arrival, and we were wondering what steps you were taking (if any) to make sure your data center doesn't see much (or any) downtime. What unique conditions...

    MelanieYarbrough6,345 pointsBadges:
  • Best book for SQL Server

    hey anybody please can anybody tell me the best book for sql server

    Naani5 pointsBadges:
  • Open IT Forum: What should system documentation look like?

    While documentation doesn't necessarily make the world go 'round, it certainly keeps it spinning neatly on its axis when trouble arises. If you're providing a product or service, you should be providing your customers with accurate information that allows them to effectively use and maintain that...

    MelanieYarbrough6,345 pointsBadges:
  • SQL query working differently in sql plus and SSSR

    I wrote down a sql query for creating a SSRS report. The query is fetching different no of rows and data in SQLPlus and SSRS. I am worried how same query can fetch different results in different environments. Please help me.

    Pradeepkiet085 pointsBadges:
  • Free IT Book: Essential Skills for the Agile Developer

    The team at Net Objectives (including CEO Alan Shalloway) has compiled the essential skills for the Agile developer. To get this resource and guide to better programming and design, simply answer one of five questions and paste the link to your answer in the discussion section below. Ultrium 4,...

    MelanieYarbrough6,345 pointsBadges:
  • problem in connect visual studio 2010 to SQL 2008

    when i am connecting the sql in my visual studio windows application to open a database file a error occurred you don't have the permission to open this file   contact the file owner or administrator to obtain the permission

    Prsaini5 pointsBadges:
  • Ageing Report T-SQL

    Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for...

    Sanisto45 pointsBadges:
  • Open IT Forum: Will HP be a worthy cloud contender?

    HP announced its Cloud Services program in beta and we wanted to know initial reactions. Have you registered for the beta? Share your initial thoughts, whether or not you have, and we'll return to this in the next phase of HP's cloud services. Share your thoughts and we'll share 50 Knowledge Points!

    MelanieYarbrough6,345 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