Online indexing is only available in the Enterprise Edition of SQL 2005.

An alternative would be to copy your table, create the index on the copy, and then do some renaming...

Ok, this is a lot of code to go through so we may need your help a bit.

What part of this is giving you a performance problem?

The first section appears...

I have run tests for a couple of production boxes. In all but situation I ended up finding that leaving memory allocation dynamic worked better. I think it...

Even Microsoft seems to have abandoned trying to make progress bars indicate how long something is going to take.

Go with a spinning wheel or something that just indicates...

I think this was just an assertive cheer.

I could be wrong.

It is really because you are using a loop to pick up the files. You probably should not, but we can handle that also.

Create 5 variables - one for...

So here is what I think you want...

You have your script task looping through a bunch of files. After all of the loops have completed successfully, you want the...

Successfully completing and being successful because you have not done anything do not necessarily mean the same thing in the precedents.

To reduce this confusion, I would put a sequence container...

It's worth trying, but I think the service pack cycles IIS when it installs.

You should also open the report from the server itself using visual studio and see if it...

Without actually seeing your SSIS package, it is going to be difficult to troubleshoot performance for you, but after having used it extensively, I will give you a few tips...

Crystal will allow you to create a pivot report like this. Reporting Services calls it a "Matrix", but I cannot remember the Crystal term for it. It may...

I have never heard of this problem before, but there were a number of RS changes from sp1 to sp2.

You should look carefully at the fix list for the service...

My review of the attached file is that the formattng is awful...

Be careful of your terms. Orphaned users are users in a database that have no server login associated with them. They will not typically hrut anything and can...

To create and test SSIS packages through visual studio, you need only install the SQL Client tools which includes BIDS. This will install visual studio with the SQL project...