After you read the manuals, and that really should be where you start, you might swing by this article[/url].

Rebuilding every six weeks or so might be OK. The real question is, how often are your statistics maintained? Those age much quicker than indexes fragment.

Chris Kitchen (8/4/2011)

---

Hi Guys,

Thanks for all your replies, at the moment there is nothing set in stone, we are just reviewing the different options available:

1. Set "Identity" to "Yes" for...

danymorales17 (8/4/2011)

---

Thanks for the replies all, first time at forums didn't know what replies I would get.

Let me ask you all this, what about Developer/QA servers. What if you...

I'd start with a search in the web site that you're on. We've got years of articles, published 5 a week. I'll be there are a ton of SSIS on...

I generally don't worry about how much I'm reading or writing on a database, but whether or not the reads or writes are slowing down. Instead of focusing on the...

If you don't get everything you need from Gail's excellent articles, you might want to pick up a copy of my book on query tuning. It might help.

No difference at all. You run a server side trace output to a file, then you open the output file using Profiler. That's it. You can then open the perfmon...

You should check for open transactions. You might have a process that isn't committing properly. I ran into some rogue code that did that & it filled the drive before...

My first choice in this situation would be SSIS as well.

But, you could look at third party tools. For example, Red Gate Data Compare[/url] could be scheduled to move data...

Connections come from the application, so that's where the code for reconnecting would have to reside.

If you're programmatically determining the key value(s), then no, having identity values isn't going to help that I can see.

Now, how you're determining that value could lead to issues. Are...

I published a series of tests on this subject for retrieving versioned data over here at Simple-Talk[/url]. It might prove useful. The answer, in a nutshell, it depends.

And you would only set it ON for the table you are inserting into, not the one you're reading from. And remember to set it to OFF when you're done.

Never heard of that. It's SQL Server Management Studio and has been for quite some time. That's where you administer your server, including security. Although, you can do most of...