• Open ended SQL queries

    Hi all, I have a requirement to trace the open ended SQL queries running in Oracle Can anyone please help me with a solution. Also please provide me some links where I can find info about Open ended SQL queries. Thanks in advance

    ssk25010 pointsBadges:
  • SQL Server 2005 Query Very Slow in the first run

    Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select...

    Jsql155 pointsBadges:
  • SQL Server 2012 Question: How to find last executed queries by database?

    Is there a way to find the last executed queries for a specific database in SQL Server 2012? I am able to find them using SSMS, but I don’t want to use SQL Profiler if I don’t have too. This is the query I’ve used to get the complete list of last executed queries. SELECT...

    ITKE54,925 pointsBadges:
  • Improving the initial speed of a SQL query

    I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • I want to select months from Jan to Dec using SQL query

    I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.

    44063860 pointsBadges:
  • MS SQL query to update a table with the last entry in another table.

    Hi, Could anyone please assist. I'm trying to update a Reporting Table with the last entry in another table. I've tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the table is a...

    GPNel200675 pointsBadges:
  • select parent where more than one child

    I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

    Ghjazz5 pointsBadges:
  • sql query

    I have stored A value in a string , when I try to use the STRING VARIABLE IN SQL QUERY DOESN'T NOT RESPOND??

    Shyamthandra5 pointsBadges:
  • AS400 – SQL

    I want to use Functions in Update Queries Set operation Update File Set FName = Substring(Name,1,10) Where EmpNo = 99 How to perform this one using SQL Queries    

    rajeshece1,215 pointsBadges:
  • Will the SQL performance improvements in V6R1 affect QUERY?

    Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

    Fw15 pointsBadges:
  • SQL Express 2005 query times lagging

    I execute some simple queries on my own system's sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server's sql server express 2005, the queries execution time is about 3 seconds or more and I don't know why. both of the systems have the same...

    Reza838325 pointsBadges:
  • On the as/400 i series can one use SQL querys to update file

    Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

    nitzinger385 pointsBadges:
  • SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • SQL query help

    Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group. PartNo------ Module------ Numbers...

    CompEng1,185 pointsBadges:
  • SQL query for same phone number

    I have 3 columns phone number, users and locations I would like to see only the name and phone numbers of the users that are calling the same phone number Not quite sure how to represent this in a SQL Statement Thank you very much for your assistance

    Iamnfo5 pointsBadges:
  • Slow SQL Query

    when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where...

    Mxaxyogesh200230 pointsBadges:
  • Update DateStructure Field through SQL Query

    I wanna update a field in the table(which is a Data Structure) through Sql Query.. Can anyone help in this regard>>

    ragav5 pointsBadges:
  • pasting a database query into crystal

    I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?

    Messe5 pointsBadges:
  • CallManager and SQL Queries

    I need to gather some data from our call manager and the reporting tool that comes packaged with the server is horrible! We have Call Manager version 6.1. Is there anyway query the call detail records other then using the reporting tool? If so, please advise me. Thanks

    Jlandon5 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