SQL Server :: Query Not Using Index?

Mar 7, 2011

I have a query:

[Code]....

was working well until I rebuild all indexes.After rebuild: The index "IX_Message" is like that:But, in QA, SQL using PK...But when I use query like that:

[Code]....

QA is:I rebuild, reorganize, delete, create again, restart sql, update statistics, etc

View 4 Replies


Similar Messages:

C# - Modifying The Query String On Dropdown Index Change In Code Behind?

Mar 1, 2011

I have a drop down box that is in the edit template of a formview. I want to be able to add a parrameter to the querystring when the drop down selected index is changed.

I tried

Request.QueryString.Add("tabindex", (sender as WebControl).TabIndex.ToString());

But I got an exception saying the collection is readonly.

Here is my markup

<icms_ref:ReferenceDropDownList ReferenceDataManagerProviderName="ROCSQLReferenceDataProvider"
ID="ddlEnquirerHearType" TabIndex="2" runat="server" ReferenceSetName="EnquiryHearType"
AutoPostBack="true" OnSelectedIndexChanged="EnquirerHearType_SelectedIndexChanged"
DataTextField="ShortName" DataValueField="ReferenceId" />

and here is my code behind.

protected void EnquirerHearType_SelectedIndexChanged(object sender, EventArgs e)
{
var pnlEnquiryHearTypeOther = fvEnquiryInformation.FindControl("pnlEnquiryHearTypeOther") as Panel;
pnlEnquiryHearTypeOther.Visible = DdlEnquirerHearType.SelectedValue == ((int)EnquiryHearType.Other).ToString();
ResetTextBox("txtEnquiryHearTypeOther", fvEnquiryInformation);
Request.QueryString.Add("tabindex", (sender as WebControl).TabIndex.ToString());
}

View 1 Replies

DataSource Controls :: SqlDataSource Query Not Using Index On Database Table?

Jan 20, 2011

I have this sqldatasource:

<asp:sqldatasource id="SqlDataSourceX" runat="server" connectionstring="<%$ ConnectionStrings:MyConn%>" providername="System.Data.SqlClient"
selectcommand="SELECT ItemNum, MIN(DateAdded) as [DateAdded]
FROM Items WITH (NOLOCK)
WHERE [DateAdded] between @DateFrom AND @DateTo

[Code]....

When I call select in codebehind, after 30sec it throws timeout expired SqlException:

[Code]....

again , this select took up to 3 sec to be executed. In application I tried to use SqlConnection and SqlTableAdapter instead of SqlDataSource, with the same query, and again it took up to 3 sec.

If I choose tighter interval (e.g '2011-01-20 00:00:00' - '2011-01-21 00:00:00') , there is no timeout exception, so I know that sqldatasource select is executed correctly. So the conclusion is that sql server is not using index while executing query sent from sqldatasource, but is using index whenever else. I have also checked the index statistics on sql server and it is like that. In profiler i can see slight difference between this two cases. As for SqlDataSource, in events table, in first column "EventClass" after 30 sec, there is this: "RPC:Completed" and application throws timeout. If i use SqlConnection and SqlTableAdapter then at the same place there is this: "SQL:BatchStarting" and "SQL:BatchCompleted" and application does not throws timeout(the index has been used).

what is so special on SqlDataSource connection, that Sql Server performs differently compared to other types of connections?

View 3 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

SQL Server :: Sub Query In Cross Table Query To Create Statistics

Mar 2, 2011

I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....

At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.

Month-download-GameID-UserID

1 1
1 1

1 1
1 1

View 2 Replies

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

SQL Server :: How To Change Cluster Index To Non Cluster Index

Nov 3, 2010

How to change cluster index to non cluster index, if it is primary key?

View 2 Replies

Databases :: Oracle Query Convert To Sql Server Query

Sep 3, 2010

I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query

SELECT DISTINCT
LEVEL LVL,
SCH.NSCHEDULE_SL,
SCH.NSCHEDULE_SL_FM,
SCH.CSHED_CNAME
FROM FA_SCHEDULES SCH
WHERE LEVEL = 1
AND NSCHEDULE_SL_FM IS NULL
AND NBRANCH_SL = 2
CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL
AND NBRANCH_SL = 2

View 1 Replies

SQL Server :: How To Copy Result Query To Another Query

Nov 4, 2010

i have tow query in one stored procedure

first query and the second one every of them return only value

i want to copy the result of tow values in a new row in new table

as i want to check on this tow values in ado.net

i want to get only this tow values as a row not first and secon query

only a row has result of first and second query results

[Code]....

View 3 Replies

SQL Server :: Select Second Query If First Query Returns Nothing?

Oct 14, 2010

How can I SELECT second if first SELECT returns nothing?

View 8 Replies

SQL Server :: How To Use Index

Nov 16, 2010

learn about Index in SQL. I know this will used to improve speed of query. but I wish to learn how it will works and how can I use it?

View 3 Replies

SQL Server :: How To Know About Index

Oct 27, 2010

I have two tables order and order details in which i have some 20000 orderNo in order table and some 80000 data in order detail table.. so i need to set index.. can any body let me know how index work and when to create index and why it usefull

View 9 Replies

SQL Server :: Get All Rows From Query A That Are Not In Query B?

Dec 17, 2010

Using sql server 2005.

I have an Query A of fields that returns X number of records.

I create a Query B of same fields that returns X-80 number of records.

I want to find out the 80 records that are in Query A but are not in Query B. what is the syntax for this?

View 4 Replies

SQL Server :: Trying To Get A Query Going In SQL Server But Get Bad/ Errors In The Query?

Nov 8, 2010

Trying to get a query going in SQL server but I get bad/ errors in the query.I have a 2 tables. One is the "Project" table while the other is the "Task" table.Table structure is as follows.

Project table => ProjectID,ProjectName
Task table => TaskID, TaskName,ProjectID,Quarter, Hours

A project can have many task. The ProjectID in Task table is the foreign key which reference the project ID.What I need to do is to SUM all the hours in the Task table and group it by quarter and then group it by ProjectID. Output of the SQL should be in the form of projectID,Quarter, Hours.

View 2 Replies

C# - Windows Desktop Search - Force Re-index / Index Now From Command Line?

May 14, 2010

I'm working on a project where we're using Windows Desktop Search (WDS) to index files on a web share and then later allow the user to search via a website for documents in the share.

These documents are transferred to the share via FTP, however it would seem that either the computer never goes idle to index or at some point the indexing stops. Is there a way from the command line or within the program itself to force this to happen without having to re-invent the wheel? Using .NET 3.5 and C#.

View 1 Replies

DataSource Controls :: Creating Cluster Index From View Error / Cannot Create The Clustered Index 'RateViewIndex'

Feb 26, 2010

Here is my code in SQL

[Code]....

Error i am facing is :

Msg 8668, Level 16, State 0, Line 2

Cannot create the clustered index 'RateViewIndex' on view 'NoteToPass.dbo.RateView' because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate function or grouping column from select list.

View 1 Replies

DataSource Controls :: Difference In Cluster Index And Noncluster Index?

Feb 2, 2010

what is difference in cluster index and noncluster index?

which is faster?how many cluster index and non cluster index per table?

what is composite primary key?on how many columns we can create composite key?

hao many maximum composite key's we can create on one table?

View 2 Replies

SQL Server :: How To Create Index For A Column

Aug 24, 2010

I need to create the index for a column and accessing that in sqlserver 2005.

View 3 Replies

SQL Server :: Index Was Outside The Bounds Of The Array?

Sep 14, 2010

i create registration form in asp.net & sql server..after fill up form when i click save button it's show error..here is my code :-

private void ExecuteInsert(string AccNo, string CompanyName, string Desc2, string RegisterNo, string Address1, string Address2, string Address3, string Address4, string PostCode, string DeliverAddr1, string DeliverAddr2, string DeliverAddr3, string

[code]...

View 3 Replies

AJAX :: Set Active Tab Index From Server Side?

Jun 9, 2010

i have tab container that contain 2 tab, one is profile view and another is profile edit there is a hyperlink in menu bar, when user click profileview then a variable '1" is send in query string, when user click profileedit then variable '2' is send my active tab index is '0' that is profileview

how to set focus on tabindex1 inside this function

if(request.querystring("a")==1)
{

what should be the code to set focus on tabindex 2

View 3 Replies

SQL Reporting :: Server Error:Index Was Out Of Range?

Dec 20, 2010

I am getting the below error when I am trying to export RDLC report data into Excel sheet using Microsoft report viewer control."Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index"

View 1 Replies

SQL Server :: How To Create Unique Clustered Index Error Message

Dec 21, 2010

I've procedure that does the below task.1. Create a #table from an existing table2. Insert data into the temp table, this copies few duplicate records into my temp table3. After insert, I'm creating a cluster index for the temp table to enhance my search option later.While creating the Index, I get the below message.[CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is 'type ad, len 16'.

View 1 Replies

SQL Server :: Import Data From One Server To Another Server Through Sql Query?

Jan 22, 2011

I want to transfer the data from one server to another by sql query. I want query. I dont know how to write?

View 2 Replies

SQL Server :: Linked Server Query / Error Authentication Failed

Dec 15, 2010

I have the following query that uses a linked server that is on a different VLAN of our network:

[Code]....

It works fine in Query Analyzer but when I put it into Visual Web Developer 2008 Express as a SQL Data Source I get an error:

"OLE DB Provider 'MSDASQL' reported an error. Authentication failed."

View 16 Replies

SQL Server :: Format Of The Initialization String Does Not Conform To Specification Starting At Index 0

Oct 15, 2010

I am getting the error above when i click on a button...

View 4 Replies







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