We updated an app recently which imposed a lot more clustered indexes then had previously been there. We also have a weekly index rebuild which I'm assuming is now running super long because of those ...

For developers working with SQL Server, few performance tuning techniques are as essential--or as frequently misunderstood--as indexing. Done right, indexing can drastically improve application ...

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database (<=13GB). I already have a weekly integrity check that reorganizes data ...