My advice is that you get a consultant to help you transition your app to effectively use sql server and to mentor you in how to better use and monitor...

That is a VERY limited and fragmented description of the problem you seek to solve, but if I read correctly I would recommend dropping the output to a file and...

Paul White (11/10/2009)

---

Oh absolutely - the discussions are probably what...

I have said this before and will say it again here: SQL Server continually amazes me with how well it keeps on chugging despite INCREDIBLY bad design, code, setup,...

If the statistics problems is because a bad clustered index choice, instead of doing recompiles every time, is not better if we avoid that problem changing the current index to...

Yeah - this was your IMPROVED design, right?? LOL

Boy, where to start with this:

1)

The recompile option will force SQL to forget about the query plan and generates a new one each time the store procedure is gonna...

See the earlier reply by richardd. It has a link to a script by Paul Nielson that not only identifies FKs missing indexes but will actually generate CREATE INDEX...

Paul White (11/9/2009)

---

Good to see you...

I think we answer quite a few exam/homework type questions. Sometimes they do evoke a good learning discourse though.

CirquedeSQLeil (11/9/2009)

---

We need more information to help. Some great comments have...

In general, nonclustered indexes (and the associated bookmark lookup to...

sqlpro (11/9/2009)

---

am not sure adding indexes on FKs. i read somewhere if your child table contains lot of unique records then there is no point of creating index as index...

I wonder if that is some sort of record? Worse than I have seen...

I have seen the use of UDFs in the WHERE clause result in FIVE ORDERS OF MAGNITUDE WORSE PERFORMANCE. Run a statement level profiler trace (preferably to disk to...