Viewing 15 posts - 35,311 through 35,325 (of 49,552 total)
Start with this two-part series. Finding the problem is more than half the battle.
I doubt there's a single, comprehensive site that covers everything. The links given earlier are good but...
December 14, 2009 at 9:22 am
Try ALTER INDEX ... REORGANISE
It does less that rebuild does, but it's an online operation.
December 14, 2009 at 9:15 am
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...
December 14, 2009 at 9:14 am
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.
December 14, 2009 at 9:13 am
That's Oracle, not MS SQL Server. You're probably better off asking on an Oracle forum what it does.
December 14, 2009 at 9:11 am
Do you have autoshrink on? Are you doing a manual database shrink after the index rebuild?
December 14, 2009 at 9:11 am
This may be of use to you. http://www.sqlservercentral.com/articles/Indexing/68439/
December 14, 2009 at 1:05 am
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
December 14, 2009 at 1:02 am
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...
December 14, 2009 at 1:02 am
ducon (12/13/2009)
December 13, 2009 at 3:48 pm
sanketahir1985 (12/13/2009)
Each & everything about clustering if possible.
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...
December 13, 2009 at 8:22 am
For all certification details, see the MS learning site - http://www.microsoft.com/learning/mcp/certifications.mspx
December 13, 2009 at 8:19 am
Bru Medishetty (12/13/2009)
Hey Gail, do you follow cricket too? I am a die hard fan of the Proteas.
I don't really. Not much of a sports fan.
December 13, 2009 at 8:17 am
Viewing 15 posts - 35,311 through 35,325 (of 49,552 total)