It really depends on what you need. For straight forward monitoring and alerting, I suggest my companies software, Red Gate SQL Monitor[/url].

If you want to get into specific query tuning,...

Microsoft provides a runtime that can be deployed. Search on MSDN. It's there.

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