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?
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..
The performance on Publisher db is acceptable but the Subscriber db is very poor. Please advise how can I mitigate this issue? As we understand the evolving reporting needs we can later fine tune and tune the performance. For now,
Will setting the following article properties act as a quick solution?
copy clustered index: Default-true
copy non clustered indexes: true
copy unique key constraints: Default-true
copy user-defined statistics: true
copy full text indexes: true ( please provide explanation)
Is it good to do index rebulid with online option when production is going on. Is there any impact?
Kindly let me know if there is any impact.
We are using Sql server 2005 standard edittion.
Thanks in advance....