View Complete Post
I have some basic code to fill items in an ArrayList as follows:
Dim intSteps As ArrayList = New ArrayList()
Select Case Session("type")
Dim j As Integer
For j = 0 To intSteps.Count - 1
Response.Write(intSteps.IndexOf(j) & " : " & intSteps.Item(j) & "<br />")
The issue is that for Case 1 the output is:
0 : 01 : 12 : 2-1 : 6-1 : 11-1 : 12
For Case 2, it's:
0 : 01 : 12 : 2-1 : 5-1 : 63 : 114 : 12
And for Else, it's:
0 : 01 : 12 : 23 : 34 : 45 : 56 : 67 : 78 : 89 : 910 : 1011 : 1112 : 12
Why is the index being set as -1 for a few items?
As subject really.
I'm talking about a complete rebuild - not an incremental, or a re-organise.
The full text indexes are only on individual tables, not Views.
I've asked a similar question before, but sufficiently different, and other is marked as Answered so thought I'd open a new Q :
Faced this question a few days back in an interview for the position of Sr. TSQL Developer.
The interviewer asked "What are bit-mapped Indexes?". Clueless I replied that, I've never heard of this type in my past experience.
Googled up and found that these exists in ORACLE.
But again to confirm, is there any type of bit-mapped index/object/concept in MS SQL Server?
I have a table which is 65 GB at present and will grow to 1 Terabyte in a year. We get data at daily level
1) What should be the maximum size of a Partition in a Partitioned Table in MBs or GBs?
In the ETL design we have followed drop index before data load and recreate it after load. But looks like this approach is time consuming.
Is there any better data load design approach? Will table partition solve this problem?
In our scenario, subscriber and publishers have same tables and we want the indexes also to be same at all places..
How to auto create (or Generate a script) which can create indexes on subscriber which are already added on publisher.. Is there a auto way or is there any article somewhere which can help..