okbangas (4/20/2012)

---

Defragment or even rebuild the index to reduce external...

First let me say that I have cursed at Crystal Reports myself on more than one occasion and have been frustrated by some of its issues. That said I can...

Sean Lange (2/7/2012)

---

I would recommend not using the local copy and always use the online copy anyway. There are frequent changes and updates to the documentation and your local copy...

savethytrees (1/27/2012)

---

Not sure how you can reduce the time taken to rebuild the indexes. But have you configured fill_factor for those indexes such that they don't get fragmented quickly. It's...

Ninja's_RGR'us (1/23/2012)

---

What's the speed gain you get from the rebuild?

This might be a case where not doing the rebuild is your best option.

Reorg is online operation so your system stays...

Unfortunately no. If I did something like that we'd risk breaking our...

Jeff Moden (6/27/2011)

---

paul s-306273 (6/27/2011)

---

As for coding, if you can't make sense of something that's been posted reasonably quickly, I suggest you move on to something that you can comprehend.

On...

The replies so far are what I expected. Based on that I have a follow-up question.

Does this approach/design method seem highly inefficient and therefore a poor choice within a...

SpringTownDBA (10/14/2011)

---

10 indexes.... design done by a developer with limited sql experience... It makes me wonder if all those indexes are needed? If you want to post the...

Lowell (10/10/2011)

---

YSLGuru (10/10/2011)

---

I guess what I don't understand about this is that because the file does not contain any data, just index information then I would think you could do...

YSLGuru (10/10/2011)

---

Perry Whittle (10/8/2011)

---

I think everybody knows where i'm...

Jeffrey Williams 3188 (10/6/2011)

---

No, this will not be possible because it isn't a backup. If you had a backup - then you could perform a partial file restore, but...

Perry Whittle (10/8/2011)

---

I think everybody knows where i'm going...

yolousa (6/23/2011)

---

Because you have lots of other ways (including SSIS) to accomplish the same and because I like separation of resposibility in my architecture and beacuse (in my view) each...

Evil Kraig F

I'm revisiting this project and after going back over the thread I had a question. For some time now we (in IT) have been manually updating data...