Click here to Skip to main content
Page 1 of 1
Page Size: 10 · 25 · 50


Tag filtered by:  Indexes [x]
Question 11 May 2013   license: CPOL
I have following table with six rowsCREATE TABLE TimePeriod( TimePeriodId int not null identity(1,1) primary key, TimePeriodName nvarchar(30) not null, OrderId int not null, sDelete bit not null default 'False')When I run this query SELECT...
Article 3 May 2013   license: CPOL
Create custom indexes for improving Mapreduce performance
Answer 22 Apr 2013   license: CPOL
I have made some changes to your block, have a look and let me know if that works...Rather then going backward (i-1, i-2), I rewrite the logic for going forward (i, i+1).So, when you are at i=0, you actually calculates slope for (i and i+1) to a max value of 9 (happyRating.size() -...
Answer 22 Apr 2013   license: CPOL
Hi,There are same issues in your code.1- The counter variable is never reseted (may be can be set to zero in another function)2- You only call the train function when counter is equal to 10 but your array only has 9 items or less, if the rating is not between 0 and 113- Another thing,...
Question 22 Apr 2013   license: CPOL
Hi folks, hoping someone can help.I have an arraylist of Integers. When there is a button click the data in the text field gets converted and added to the array list as an int. You can see, once there has been ten submissions (counter takes care of that) it calls the function train();. Here...
Answer 8 Mar 2013   license: CPOL
This will be understandable..http://www.c-sharpcorner.com/uploadfile/nipuntomar/clustered-index-and-non-clustered-index-in-sql-server/[^]Clustered and Non-Clustered Index in SQL 2005[^]
Question 8 Mar 2013   license: CPOL
Dear All, could anyone suggest me the good link to understand the index in sql server, i am trying to understand from usual articles but, i can not, I do not want theory, i just want logical working of clustered and non-clustered index in sql server.Any help will be highly appreciated.
Question 16 Feb 2013   license: CPOL
Dear Coders,I've just started using your ImapX library to retrieve and read mails from gmail.Now, everything is working fine and it's a great library.However, when i'm trying to mark a mail read using the Message.Process() option, it returns the IndexOutOfRangeException.private...
Answer 16 Jan 2013   license: CPOL
Google[^] gave me about 1,140,000 results when i entered this question's subject in search query. Next time you post a question in this forum make sure you have googled for the information. If you are not good in searching for information through google go through the below article. You might...
Answer 16 Jan 2013   license: CPOL
check this link.http://www.c-sharpcorner.com/UploadFile/senthurganesh/109172007050741AM/1.aspx[^]
Answer 16 Jan 2013   license: CPOL
Understanding Indexer in C#[^]
Question 16 Jan 2013   license: CPOL
how we will create indexers in c#.net,different types of indexres in c#.net
Answer 2 Jan 2013   license: CPOL
A clustered index is a special type of index that reorders the way records in the table are physically stored.Therefore table can have only one clustered index and this is usually made on the primary key. The leaf nodes of a clustered index contain the data pages.A nonclustered index is a...
Answer 12 Dec 2012   license: CPOL
If DGV1.SelectedRows.Count > 0 Then ENDROW = DGV1.SelectedRows(0).Index STARTROW = DGV1.SelectedRows(DGV1.SelectedRows.Count - 1).Index Dim TEMPROW As Integer If ENDROW
Answer 12 Dec 2012   license: CPOL
as below...dim First_selected_row_Ind = dataGridView1.SelectedRows(0).Indexdim Last_selected_row_Ind = dataGridView1.SelectedRows(datagridview1.selectedrows.count-1).IndexHappy Coding!:)
Question 12 Dec 2012   license: CPOL
Dear professionals, simple dummy question from beginner. in my app the user will select the rows in the data GridView.i want to get the start and end indexes of his selection.
Answer 11 Dec 2012   license: CPOL
Copy large amounts of data into a table is a balancing act between the data you are inserting and the indexes on that table. Have a look at this question on stack overflow...http://stackoverflow.com/questions/6955456/drop-rebuild-indexes-during-bulk-insert[^]"There is overhead in...
Question 11 Dec 2012   license: CPOL
Hi,I need to copy a parent tabel into another child table.where the parent table contains a lot of records i.e about 22224171 records.I need to decress the copying time. i have already applied index to 4 columns in the child table.Could any one help me to solve this performance...
Question 21 Nov 2012   license: CPOL
Hi All, I am facing one issue can you give me suggestions.Question:Suppose we have a classClass A{ string Fun1(){//some logic return String}; Int Fun2(){//some logic return int }; objClassXyz Fun3(//some logic return object of class ClassXyz);}Now I will inherit...
Answer 4 Oct 2012   license: CPOL
You are accepting changes before adding the new row. Nothing will happen then.DataRow sh*t = finleTable.Rows[i];finleTable.AcceptChanges();finleTable.Rows.Add(dr);Try this:DataRow sh*t = finleTable.Rows[i];finleTable.Rows.Add(dr);finleTable.AcceptChanges();
Question 4 Oct 2012   license: CPOL
Datatable dt2=getEmaployeeData(); foreach (DataRow erow in dt2.Rows) { employeeid = erow["employee_code"].ToString(); employeeName = erow["employee_name"].ToString(); hodID =...
Answer 19 Sep 2012   license: CPOL
Please go through 1. Clustered and Non-Clustered Index in SQL 2005[^].2. Overview of SQL Server 2005/2008 Table Indexing (Part-1)[^]3. Database performance optimization part 1 (Indexing strategies)[^]4. Speeding up database access - Part 3: Fixing missing indexes[^]
Question 19 Sep 2012   license: CPOL
what is the difference between clustered and non clustered index in sql server. what will we use while designing table in sql server.
Answer 22 Aug 2012   license: CPOL
There could be a host of different reasons for this. First of all, two bone weights is too low. 4 is respectable. But this is most probably not the problem.The problem could be bad math in your vertex shader. In any case, you would need to provide more info for us ti diagnose the problem....
Answer 29 Jul 2012   license: CPOL
Thanks strogg. You are absolutely correct.Actually my problem is I am dynamically setting the data like SerialNumber etc in newly created row which gets updated into datasource and then goes to the client side where this new row is reflected in datagrid.I have an idea about solving this...
Answer 27 Jul 2012   license: CPOL
The NewRow() simply creates a row with the schema of the table. It does not add the row to the DataTable & you cannot get the index until you add the new row to the table. Here's an example(assuming dt is the DataTable)Dim row As DataRow = dt.NewRow()' IndexOf() will return -1 if called...
Question 27 Jul 2012   license: CPOL
Hello,On some event, I am adding a new row in DataTable using NewRow function. which results in calling another event of DataTable "OnColumnChanged". I want to get a RowIndex of recently added row.When I try to obtain row index of newly added row using code : lDataRow =...
Question 24 Jul 2012   license: CPOL
I have combobox1 and comboox2 and in combobox1 my elements are A,B,C and combobox2 a,b,c,d,e,f...And I added this elements using property screeen(I mean not with code).combobox1 combobox2 ----------------- ---------------- A ...
Answer 24 Jul 2012   license: CPOL
The connection between the items in the first combobox and the second combobox is modelled also somewhere else (at least ought to be), e.g. in a table in a database or in a linking class.That means, in the SelectedIndexChanged event of the first combobox (note: check that it is not -1!), you...
Question 27 Jun 2012   license: CPOL
Hello. I am currently working on a rendering engine which is meant to render character animations. Right now I am working on vertex blending to make the body parts move with the bones.For each vertex declaration, I have a short that represents the first bone's weight, and 2 shorts...
Technical Blog 5 Jun 2012   license: CPOL
Finding and removing indexes in SQL server is an excellent way to remove bottlenecks, especially if you've "inherited" the application or (like me) you've spent so much time on application code that databases have been a bit of voodoo. It's an easy thing to do, and can have dramatic effects.
Answer 25 Apr 2012   license: CPOL
The Array.Sort(Of TKey, TValue) Method (TKey(), TValue(), IComparer(Of TKey)) explained here http://msdn.microsoft.com/en-us/library/x8kwfbye.aspx[^] can be used for this purpose. In the present case, as the sorting is to be done in Descending order IComparer is required, which is explained here...
Question 25 Apr 2012   license: CPOL
Dear All,I have two arrays (array1 and array2)with double type data. I want to sort array1 to ascending order, and array2 with corresponding to the array1 indexes. Is this possible? Example below,Array1(0) = 2.30 Array1(1) = 4.20Array1(2) = 1.90Array1(3) = 0.20Array1(4) = 0.88...
Answer 22 Apr 2012   license: CPOL
Hi,I had this issue personnaly and did not have the luxory of an additional server.My reports needed to be correct as of close of business the previous day. So what I did was to perform overnight jobs with the complex queries in question and storing the results in a flat file. Then I could...
Question 17 Apr 2012   license: CPOL
We use sql reports in a dot.net web application but some of our reports are heavy and involve more table join and columns. as u know we cannot index all the involved columns(performance problem).these reports impact web application performance. now we are running reports against the same...
Answer 6 Mar 2012   license: CPOL
Thanks for the info Hogan! I'll do some testing to see what's best. I wasn't sure if I had completely run off the tracks!
Answer 5 Mar 2012   license: CPOL
Rich,My experience is with SQL Server 2005 for what it's worth. I don't know that combining the two tables is a good idea. Indexing is a bit of an expensive operation in terms of adding and removing records. Once the index is complete, the searching and retrieving of records is quite fast....
Question 5 Mar 2012   license: CPOL
Hi folks,This is a 'best practices' question. I am replacing an application that used the Unidata (Pick like) database. The application itself is a messaging process, which is not a problem, neither is the setup of the table. My question is of an index nature. In Unidata, there is a small...
Question 26 Jan 2012   license: CPOL
Hi all,I need to create a document store with search capabilities. Sounds simple... That means that I have documents which I need to store in database. I thought about CouchDB, and about few other document-oriented databases, but I'm still not sure what would be the best solution.On...
Answer 20 Nov 2011   license: CPOL
You need to show the HTML code with menu you use to get to this "primary content page" or your AJAX call if you use any, but basically the problem is simple:The PHP variable _GET is an associated container of form data using HTTP method "get" indexed by keys each representing a name...
Question 20 Nov 2011   license: CPOL
I'm working on a php website for my class. I'm currently in the process of learning and understanding the switch code, and how it utilizes the menukey index. For some reason I keep getting this error on my page "Notice: Undefined index: menukey in D:../../../../index.php on line 24". However...
Article 23 Aug 2011   license: CPOL
In this second part of series of articles about database performance optimization I will discuss about index maintenance.
Article 20 Aug 2011   license: CPOL
In this first part of series of articles about database performance optimization I will discuss about indexing strategies and index maintenance.
Answer 16 Aug 2011   license: CPOL
Most likely the background population you saw is another term for tracking changes.If you add large amount of data in your nightly operations, I would suggest that you drop the index before nightly operations, do the operations and then create the index again (so not using rebuild). When...
Question 16 Aug 2011   license: CPOL
I have a table with a full-text index that is essentially a denormalized view of several tables that is automatically updated when any of the base tables are updated via triggers. This table is primarily used for a nightly operation, but I would like to use it for more real-time things if I...

Page 1 of 1


Advertise | Privacy | Mobile
Web02 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid