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
How to change cluster index to non cluster index, if it is primary key?
View 2 Replieslearn 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 RepliesI 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
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#.
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.
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?
I need to create the index for a column and accessing that in sqlserver 2005.
View 3 Repliesi 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]...
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
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 RepliesI'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 RepliesI am getting the error above when i click on a button...
View 4 RepliesHow can I get the active index of the jquery accordion pane when a button is clicked? What I want to do is when a button is clicked in pane 3 for example, I want to store that value and when the page is reloaded, I want pane 3 to remain open.
I intially had this in my server side click and when I hard code a value in for paneIndex it works fine, but obviously, I don't want to do this, I want to get the index on the click and pass that to the script.
string script = "<script type="text/javascript">var paneIndex = " + 3 + "</script>";
if(!ClientScript.IsStartupScriptRegistered("JSScript"))
ClientScript.RegisterStartupScript(this.GetType(),"JSScript", script);
i get the error:Format of the initialization string does not conform to specification starting at index 0
when i submit information on button click.
I am using SQL2008 and created a full-text index on 1 of my tables. Going through the wizard, I was offered (2) types of population schedules as follows:New Table Schedule: Define a population schedule for a table.New Catalog Schedule: Define a population schedule for a full-text catalog.I am familiar with a 'Catalog' schedule for population which I do nightly and was similar to configuration on SQL2000 for a full text index. However, what is the difference for a 'Table' schedule vs the 'Catalog' population schedule? I have the definitions above, but if someone with knowledge could offer a better in depth explanation in comparison, and if I should use both or not (I have just a Catalog population scheduled currently),
View 1 RepliesI have a column in SQL Server 2008 called MapLocation which is stored as the geography data type. This column is used to store the location of a building in one table, and the location of landmarks in another table. I have to list all landmarks within 4 miles of a building.
I have a clustered primary key on an automatically generated int column in each table. I assume that I need to create a spatial index on the MapLocation column in the landmarks table. This I guess would aid finding all landmarks within 4 miles.
My problem is that I am not sure what settings to use for this spatial index. I have set the spatial index to have the following settings:
Cells per object: 16 Level 1: Medium Level 2: Medium Level 3: Medium Level 4: Medium Tessalation Scheme: Geography gridAre these the best settings? Am I doing the right thing?
I have two control page in my aspx page. first one left side "tree view",second one right side " form design".Form design will change based on tree view selected index changed.i have 4 level child node(site, master , slave, space). I have seperate forms to each level of node.
cannot update tree node when update the forms. so i reload tree view.
now i need how to auto selected index change to tree node.
ex.
1 parent node
1.1 child node
1.2 child node
i have update "1.2 child node" rename to "1.3 child node"
and reload treeview so it will chage...
how set tree node.selected index = 1.3 child node....
gvOff.DataSource = o.ViewData(dCity.SelectedValue);
gvOff.DataBind();
gvOff.Columns[0].HeaderText = "ZZZZZZZZ";
gvOff.Columns[1].HeaderText = "YYYYYYYY";
gvOff.Columns[2].HeaderText = "XXXXXXXX";
Header count is correct.
AutoGenerateColumns: Flase/True ( i tried both)
If i remove the gvOff.Columns[index].HeaderText portions, GridView works fine, but when i put the gvOff.Columns[0].HeaderText, i get the exceptional error.
, i couldn't solve it. If you need further info, inform me.
EDITED:
Hold on! I commented the HeaderText portion and tested
int i = gvOffer.Columns.Count;
I found count is 0 eventhough the columns print out with DataBind()... Why?
NOTE: AutoColumn in this case is set to true. I guess i will have to edit the column
names from DataTable.
where should we use clustered index and non clustered index.i mean in day to day use which on e to choice and how to make decision.
View 8 Replies1) we have only one select query to select 5 column form the table(i.e. select col1,col2,col3,col4,col5). so in that case should we go for stored procedure Or we can directly write the select query in the .Cs file only ( means in Database layer). when we should go for the SQL server stored procedure and when we should go for in line query in Visual Studio itself.
2)how to decide when to use Clustered and when to use Non Clustered index?
Currently we are saving files (PDF, DOC) into the database as BLOB fields. I would like to be able to retrieve the raw text of the file to be able to manipulate it for hit-highlighting and other functions.Does anyone know of a simple way to either parse out the files and save the raw text on save, either via SQL or .net code. I have found that Adobe has a filtdump utility that will convert the PDF to text. Filtdump seems to be a command line tool, and i don't see a way to use a file stream. And what would the extractor be for Office documents and other file types?-or-Is there a way to pull out the raw text from the SQL Full text index, without using 3rd party filters?Note i am trying to build a .net & MSSql solution without having to use a third party tool such as Lucene
View 5 RepliesI have a problem with my site created with Share Point Portal. This morning I launched a specific link I came out this error: Index was outside the bounds of the array.Server Error in '/_layouts/incident' Application. Index was outside the bounds of the array. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array. Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[IndexOutOfRangeException: Index was outside the bounds of the array.]
Incident.ActionResponse..ctor(SPListItem item) +290
Incident.ActionResponseCollection..ctor(SPWeb web) +96
Incident.Incident.Page_Load(Object sender, EventArgs e) +1089
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
What options are available for indexing site content in an ASP.NET web site? I suspect SQL Server's Full Text index may be used if the page content is stored in the database. How would I index dynamic and static content if that content isn't stored in the DB, but in html and aspx pages themselves?
View 5 RepliesI have a sprite image that is the background of a div and the div contains "li" elements with anchor links in them..I want that when user hovers over links ..diff parts of sprites' image are displayed in div's background..
now sprite was working great until I added a master page to my aspx page..the image hid behind the "Links"..but when I removed the Z-Index property in my css..the image appeared but the links got behind the image :/ so cant hover over links and test if the sprite is working or not. now how do I set this z-index property so it works fine?
