Sue_H
Thanks for the guidance. I don't have enough rights to create user defined role in SSRS. So I go for Content Manager route.  This was I did.   
-Create...

Both Farlzy & Jonathan's solution give me exact what I need. I...

Thanks for following up. I came cross an instance that we have to update and delete 20+ millions of records from the table. and that has been extremely slow, although...

Alright! After spending another couple hours with a magnified glasses and couple packs of cigarettes I found the source of the issue. Those children nodes with multiple parents is the...

Alright understood. But i think what sql did to us was not fair and uncool!

I guess I answer my own question. Found out that the table contains a column with image datatype is not allowed online rebuild.

This column needs to be on...

I heard it is stored by the clients...

I found the script below while googling it sort of working but it is really slow sometimes the result doesn't come back until the index rebuild is completed, so it...

Let me try to explain: the feed to our...

Good morning!

It seems the SQL bulk copy failed has many things to do with my auto-reindex stored procedure. Our application called this stored procedure every 20 minutes or so to...

Erland Sommarskog (7/16/2013)

---

When 15000 rows have been loaded, someone trips on the network wire and the client is disconnected. With no BatchSize set, all 15000 rows are rolled back. With...

Erland Sommarskog (7/16/2013)

---

You need bitwise or, that is the | operator, if remember the C# syntax correctly.

Then again, if there are queries running against the table, while your loading, they...

I set both SqlBulkCopyOptions.TableLock , SqlBulkCopyOptions.CheckConstraints but still getting the same issue.

Anything else you could think of? Maybe I did not set the TableLock correctly? Should it be:

Dim...

Erland Sommarskog (7/15/2013)

---

haiao2000 (2013-07-15)

---

I think you are absolutely right, especially on #4, I know for the fact that our application has some built-in auto index feature that checks the table...

I have not tried to recreate indexes as at this point I am focusing...