I'm with Gail on this one. Fixed values are much better. You always know exactly how much will be added and you can anticipate the additional load that will place...

Nope. Especially not a unique index. If it's unique, it's unique. If someone types Heme, Hem or Ham, they're all going into the database.

I have to ask, why no backups?

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...