DataSource Controls :: Query Slow And Timedout Error?

Jun 6, 2010

I have 2 tables with Primery Key in both table and 700k in each tables and i am direct executing following Query in SQL Server 2008

[Code]....

Its speed very slow and then timedout error. My system configuration is good and i am not executing it online but offline on my laptop.

View 3 Replies


Similar Messages:

SQL Server :: Query Slow In Loading / Trying To Display Query Result?

Feb 1, 2011

I am trying to display this query result in an aspx page.

It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)

select

top 500

--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables

View 7 Replies

DataSource Controls :: Select Query Not Working / Getting An Invalid Column Name Error?

Jul 9, 2010

i have the following select staement which deosnt work, can anyone advise me whats wrong with it:

string _name = ddl_Name.SelectedValue.ToString();
string cmd =
"SELECT ID, Telephone FROM User_List WHERE Name = '' + _name;

i keep getting an invalid column name error? and i know the syntax next to _name isnt correct. how are the single quotes meant to go?

View 3 Replies

DataSource Controls :: Update Query Error - Incorrect Syntax Near 'nvarchar'.?

May 3, 2010

I have this SqlDataSource:

[Code]....But when I click Button Update this error occurred:

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'.

View 5 Replies

DataSource Controls :: Error When Testing Query During Configuring Sql Data Source For Gridview?

Oct 18, 2010

I got the following error message:

There was an error executing the query. Please check the syntax of hte the command and if present, the types and values of the parameters and ensure they are correct. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

But when I run the query through Management Studio, I can get the result.

There are no parameters for this query either.

View 1 Replies

DataSource Controls :: Aplication Real Slow, Using Sqlhelper

Dec 18, 2010

I hired some to write a ecommerce website for me.and the used SqlHelper.GetInstance().ExecuteDataSet stuff i'm not familiar with.
But is real slow .
Screenshot of trace,page takes like +20 sec to return like 20 records of 3 field each!The DB queries are good, use same SP on my own app and it takes les then 1 sec.Did they use the sqlhelper wrong? is sql helper that slow?

View 1 Replies

SQL Server :: Query Is Running Very Slow

Mar 19, 2011

The below SQL query is running extremely slow. Im using this query on other tables and its processing about 5 rows per second. The below version is running 1 row every 10 seconds when @SQLNew is executed.

[Code]....

View 5 Replies

Access :: OleDB Query Is Too Slow?

Jun 15, 2010

im using an access database with less than 50.000 records on a single table, no relations.

ive put the following code inside a two for cycles as per the respective variables (i, j) the connection is opened outside the outer cycle and closed after it, im holding the connection open to save up on open/close time and im using OleDB thinking it would be faster than ODBC. The ds fill operation takes nearly 3 seconds in debug mode, the total process will require almost 4 hours. How is it possible to speed it up?

[Code]....

View 4 Replies

DataSource Controls :: SqlDataSource And Parameters Query / Trying To Accomplish Is Building Dynamic Query

Aug 22, 2010

1. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like

SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.

Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).

2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query

(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).

If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.

View 11 Replies

DataSource Controls :: Update Query Not Working When Using Query Builder To Configure Table Adapter

Jan 15, 2010

[code]...

This query works perfectly on the query analyser.

But when configuring the Table adapter ,I try executing the query and i get 0 rows affected.

What could I be getting wrong in this case.

NB:Existing GalleryID has been supplied.

View 1 Replies

DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?

May 17, 2010

By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.

View 10 Replies

DataSource Controls :: SQL Server SELECT Statement Is Slow In Large Tables?

Jun 1, 2010

I'm facing a problem in our current running application. There is a table in database which has 67 columns,among these 18 columns are nvarchar(max) datatype and contains 30K records. Problem is now that SELECT * FROM myTable it takes around 3 to 4 seconds. Which is degrading our application's performance.

View 12 Replies

Slow Query When Connecting To Linked Server?

Nov 18, 2010

I've got this query UPDATE linkeddb...table SET field1 = 'Y' WHERE column1 = '1234' This takes 23 seconds to select and update one row But if I use openquery (which I don't want to) then it only takes half a second.

The reason I don't want to use openquery is so I can add parameters to my query securely and be safe from SQL injections. Does anyone know of any reason for it to be running so slowly?

View 4 Replies

DataSource Controls :: How To Convert Sql Query Into Linq Query

Mar 10, 2010

select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid

View 5 Replies

DataSource Controls :: Accessing FK From A Query Via Entity Query

Jan 21, 2010

I've got a query such as

Dim MediaQuery =
From m
In dB.DOWNLOADS _Where m.ID = id _Select

which returns a record from the database. One of the fields in the record is a FK to another table. I need to read this value to be able to set a dropdown based on the ID but I can't work out how to access it. For a standard record I can just do the following txtTitle.Text = MediaQuery.FirstOrDefault().TITLE

However with the foreign key it doesn't work like that. I've tried drpGroup.SelectedIndex = MediaQuery.FirstOrDefault().DOWNLOAD_GROUPS.ID where DOWNLOAD_GROUPS is the FK field but it returns Object reference not set to an instance of an object. If you're simply wanting to read some values from a single db record in the entitiy framework and one is a foreign key how should I go about getting the value?

View 2 Replies

SQL Server :: Query Slow On Large Volume Of Data?

Dec 27, 2010

In my database when I fire query it takes 40 secs on 1 crore data, similar when I use join with other table then it take more time. I have taken care non cluster index such thing. But still I want to optimize my query, what other thing I need to take like buffer, disk size etc. I am not sure on this area.

View 11 Replies

SQL Server :: Slow Running Query Based On Multiple Tables Using Joins

Nov 15, 2010

One of my peer wrote a query based on multiple tables using joins. One of the table is in a different database The query was taking much time

1. Create an SP
2. Create a temp table and copy all records from the external db
3. Avoid using Left Join as much as possible and use Inner Join
4. Create and use indexes
5. Remove tables/columns that are not necessary

In this scenario, I would like to suggest to use Covering Index, but how can it be created for multiple tables and a temp table?

View 3 Replies

ADO.NET :: Execute Update Timedout Expires , Table With Trigger Due To Recovery Of Database?

Aug 20, 2010

I have table A in database A , in table A i have trigger to insert record to database B table A, each update and insert of database A -table A, triiger fire and insert record in database B table A, when i try to update some times asp.net application gives error

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

and then error log says System.Data.SqlClient.SqlException: Database 'database B is being recovered. Waiting until recovery is finished.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)[code]....

View 1 Replies

DataSource Controls :: SSIS Job Failed With Error Error Code: 0x80004005 OLEDB Error

Jun 6, 2010

Error:
Executed as user: MACSTEELUSA.COMsa. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:17 PM Error: 2010-06-02 20:00:18.56 Code: 0xC0202009 Source: CRM_ORACLE_ARSUMMARY Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client
and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". End Error Error: 2010-06-02 20:00:18.58 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireCon... The package execution fa... The step failed.

Tasks Taken:Went to this folder checked for tnsnames.ora file but it is in good shape.

C:ORACLEproduct11.2.0client_1
etworkadmin

View 2 Replies

Web Forms :: Using The Code Below But It Is Very Slow, Plus When Close Web Page Get An Error?

Jun 12, 2010

I have a textbox that I need to make sure the case is right. I am using the code below but it is very slow, plus when I close my web page I get an error.

[Code]....

View 4 Replies

DataSource Controls :: Not Able To Run SQL Query Using If Else?

Apr 21, 2010

I am using Querystring "ddl4" to pass on value of a drop down list to the next page where I am using that value in the WHERE clause of a SQL command. I also need to check whether ddl4 is blank or not which I do using If Else in SQL command. I am not able to run the query where the Querystring ddl4 IS NULL

This is the sample link with the Querystring ddl4 carrying a blank value:

[code]....

View 2 Replies

DataSource Controls :: How To Run Sql Query From Project

Apr 13, 2010

I have one query in my project (saved in folder SQLQueryes, Query.sql) and i need to execute it. Also, i have one parameter in script and i need to include him also. How?

View 8 Replies

DataSource Controls :: SQL Query With IF And Select

Feb 18, 2010

SQL Query with IF and Select

View 2 Replies

DataSource Controls :: Why We Need Union Query

Jun 10, 2010

if there is no relation bettwenn two tables why do i need union for example like below Please
can u inform me

SELECT categoryId
FROM categories
UNION
SELECT shipperId
FROM shippers

View 3 Replies

DataSource Controls :: Query Using Linq To Sql?

Jun 25, 2010

I´m using Linq to Sql in my asp.net application, but the problem is:I have a query like this:

[Code]....

My query is not returning anything, how do I do to get this?my problem is with this interval I need to have.

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved