.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

Reorganize index order

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
 
Hi experts, If a table has mulptiple indexes (cluster and NCluster index), which index should be reorganized first? I know if you want to rebuild index, you want to start with Cluster index and then do the rest (NC index) Regards


View Complete Post


More Related Resource Links

What is the meaning of Ascending\descending sort order of a column within an index

  
When I add a new index I can also specify the "sort order" as ascending or descending. What does it mean? does it affect performance? does it mean that the binary search tree will be set in a certain way?

index maintenance -- Reorganize

  
Hi experts, I m trying to find a way that if its possible to reorganize index (as its online process) in a way that it will only run for 1 hour and then resume next day for another hour or so on.. Regards

WPF datagrid Tab Navigation problem not following tab index order

  

Hi

I have designed a wpf page with 3 textbox than a datagrid than again a text box

and I have set the tabindex to first 3 testbox 1, 2, 3, than 4 to datagrid and 5 to last testbox

But when I run page and press tab to navigate,first three textbox are ok they follow tabindex but when I tab to navigate to datagrid it jumps to forth textbox and again on next tab go to datagrid. means after navigating all of the four textbox its go to girdview.

Please tell me how I can set tab order?


WPF datagrid Tab Navigation problem not following tab index order

  

Hi

I have designed a wpf page. But I not able to set Proper Tab Navigation on it. Controls (Specialy datagrid) on the page are not following tab index. 

It has a group box inside which there is a grid. this grid has rows and columns. In first three rows contains textboxes. 4th row contains  the datagrid forth row spans to 5 cols. in next row it agains has textbox and after that it has 3 buttons

Following is the design view, Run time view with tabindex which I have given to them and arrows show the index they are following.

I am loading datagrid with a object of list of items which has one object of type item. so as per my thinking it is not empty it has data in it. as you can see in run time view


Changing Z-index order programmatically in C# with Control.SetChildIndex?

  
Hello developers.

I've recently build a Windows form app that contains 18 pictureboxes and 1 button.
I want the boxes on the bottom of the form to be on the front, so they overlap all the others.
And the boxes on the top of the form must be on the back, so they are behind all the others.

I can manually do this with 'move to front' and 'send to back' options, but I want to to this programmatically.
This is so, because I'm gonna add another picturebox that can move.
That picturebox should automaticly change it's z-index when it's Y changes.

At the moment the 17 pictureboxes have a random 'z order':
Some pictureboxes are on top, some are on the bottom, in a random way.
Now I want to set the z order correctly when I click on the button.

I've made code that sets the ChildIndex between 1 and 5 depending on the Y of the picturebox.
When the Y = 0, the ChildIndex will be 5, and when the Y = 400, the ChildIndex will be 0.
The pbBackground is also a picturebox, and this one's ChildIndex = 10.

My problem is, that my Windows form app isn't doing what it's supposed to be.

The picturebox names are pictureBox0, pictu

Sorting ORDER BY - WORD

  

Is it possible with SQL sorted in descending order according to the word?
In Table I shrajeno Mastercard, Visa, Diners etc ...

All Visa are the first in the order, another Mastercard, etc. ...

Something does not work: ORDER BY PaymentType = 'Visa';

I would not want to work in one field PaymentId (111,222,33, etc. ..) and then use the ORDER BY.

Is this possible in such a way?


Linq qry with order by basic questions

  

I have never tried a group by with linq, now I do and I'm stuck.

I try to convert this sql statement to its linq counterpart :

SELECT COUNT(tb_Mailer_Smses.Id) AS [cnt], tb_Mailer_mailing.Id As [Id]
,SUM( CASE WHEN tb_Mailer_smses.DLRStatus = 200 THEN 1 ELSE 0 END) As [Delivered]
,SUM(CASE WHEN DLRStatus BETWEEN 300 AND 499 THEN 1 WHEN DLRStatus BETWEEN 800 AND 899 THEN 1 END) AS [Errors]
FROM tb_Mailer_mailing INNER JOIN
tb_Mailer_Smses ON tb_Mailer_mailing.Id = tb_Mailer_Smses.MailingId
WHERE tb_Mailer_mailing.ApplicationId = 1
GROUP BY tb_Mailer_mailing.Id


Is there some one who can me show me the convertion process ?


ASP.NET: Collect Customer Order Information on an Internet Site Using XML and Web Forms

  

XML has quickly become the new data structure standard for everything from database access to cross-platform computing. XML is typically considered to be a vehicle for data exchange, dynamic data presentation, and data storage. However, the potential of XML far surpasses those limited applications. This article examines one new use: the gathering of data across a number of forms in an ASP.NET Beta 1 framework application. The sample program is a Web app used for ordering pizza. It uses ASP and C# to gather order information and then stores it in XML. To build the application, several concepts are explained, including data collection, order persistence using cookies, grouping input forms, and formatting the data for display.

Jeff Jorczak

MSDN Magazine September 2001


order by in combination with union

  

 Hi All,

How can I order this by count? so if it appears above and below the union statement, I want it on top

	SELECT distinct BIER.Naam, BIER_L2.L2_Naam, BIER_L3.L3_Naam from BIER_MATCH, BIER, BIER_L2, BIER_L3
	where BIER_L2.L2_ID = BIER.L2_ID and BIER_L2.L3_ID = BIER_L3.L3_ID and BIER.ID = BIER_MATCH.BIER_ID 
	and RECEPT_ID = @RECEPT_ID 

	
	UNION  
	
	--L2
	SELECT distinct BIER.Naam, BIER_L2.L2_Naam, BIER_L3.L3_Naam from BIER_MATCH, BIER, BIER_L2, BIER_L3
	where BIER_L2.L2_ID = BIER.L2_ID and BIER_L2.L3_ID = BIER_L3.L3_ID and RECEPT_ID = @RECEPT_ID 
	and BIER_MATCH.BIER_ID is null


 


how to create index for a column

  

Hi Friends,

                       I need to create the index for a column and accessing that in sqlserver 2005. Please any one help me.



Thanks..,


Deleting items from the index (custom protocol handler)

  
I created a custom protocol handler. I successfully emit entries into the index. I just can't seem to delete them during an incremental crawl.

I tried:

1. no emitting child item during the enumeration of child entries in a folder
2. returning PRTH_E_OBJ_NOT_FOUND from CreateAccessorEx

doing either 1, 2, or both did nothing. The entries are still there.

what i need to do to delete these entries from the index during an incremental crawl?

Thanks.

Ingest google Search Index into Sharepoint 2007

  

Hi Folks

 I am wondering  if there is a way to ingest google search index into SharePoint index such that when people search via SharePoint they see the Google results too… incorporated/federated inline with the SP results (not as a separate "box" ).

We have Google search in our environment and also share-point search. Share-point search for sharepoint site but Google search is for all other environments. Now i am thinking if we ingest the Google search index into share-point then may be its great deal to provide user a platform to search everything on one place.

 

thanks

ws


i am at entry level administrator
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend