Start with this two-part series. Finding the problem is more than half the battle.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

I doubt there's a single, comprehensive site that covers everything. The links given earlier are good but...

Try ALTER INDEX ... REORGANISE

It does less that rebuild does, but it's an online operation.

Looks like the server went off the network or shut down. Check that the server's running, check that SQL's running and try running checkDB again. This is not a checkDB...

Table definitions, index definitions and execution plans please.

Does sound like parameter sniffing. There's a 3-part series on my blog (http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/) on parameter sniffing. It may be worth a read.

That's Oracle, not MS SQL Server. You're probably better off asking on an Oracle forum what it does.

Do you have autoshrink on? Are you doing a manual database shrink after the index rebuild?

This may be of use to you. http://www.sqlservercentral.com/articles/Indexing/68439/

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic833628-148-1.aspx

Which one are you working with? 2005 or 2008? I'd go for the one that you're activly working with, that you ave experience with.

As for admin vs dev, well, which...

ducon (12/13/2009)

---

I'm in the process of indexing a few columns in a few tables, most of which are of type nvarchar(515). This means that the byte size if over the...

Those are big enough that there should be a reduction in fragmentation after a rebuild. Small ones often don't show much if any change.

Everything? There have been entire books written on clustering that still don't cover everything. I don't think that anyone's going to give you...

For all certification details, see the MS learning site - http://www.microsoft.com/learning/mcp/certifications.mspx

I don't really. Not much of a sports fan.

How big are those indexes? How many pages?