That's normal.

I can't see anything catastrophically wrong. Not like the 'fixing of a suspect DB earlier this week'

Yes, the index diagram is slightly incorrect (the root has a single page), the...

First question: Why do you need to rebuild the transaction log? That's not something to do lightly.

Take a look at this: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

The fact that DTA doesn't find anything, doesn't mean that there isn't opportunity for improvement. DTA is questionable at best.

Searchable ARGument. It means a predicate in the where clause that can be used for an index seek operation. As a very high level summary, that's...

Yes, it is possible. Same as installing two instances anywhere.

Joy Smith San (2/11/2010)

---

I have read enough abot performance tuning and have started accumulating the necessary data. But still can you just brief me the steps I need to do...

Someone (who's using a computer with the name given in hostname XYZ) is running the KILL command and killing processes.

Find the person and tell them to stop.

That's likely not the...

It's highly unlikely that you're going to get all the data back....

That's a really vague question. There's nothing inherently wrong with nested loop joins and constant scans. Is it slow? Is there blocking? Are there timeouts?

DTA indexes should be tested and...

You don't need to enable traceflag 3605.

1204 writes the deadlock graph into the error log

1205 writes some of the deadlock search info into the error log.

3605 redirects some output...

RBarryYoung (2/10/2010)

---

1) Goto my blog site and download my presentation "TheTop Ten Reasons You Aren't already using Service Broker", or "Top 10 Fixes for your first Service Broker project". ...

Jeff Moden (2/10/2010)

---

I'm not sure if they've fixed the problem yet or not but my understanding is that 64 bit versions cannot use JET drivers... that pretty much kills things...

Enterprise edition only.

Bill Jackewicz (2/10/2010)

---

1.) While the ROLLBACK is being processed, will dropping the indices have any affect, good or bad?

2.) What happens if I issue a TRUNCATE TABLE...