Viewing 15 posts - 41,431 through 41,445 (of 49,571 total)
Jeff Moden (1/26/2009)
January 26, 2009 at 11:51 am
madhu.arda (1/26/2009)
January 26, 2009 at 11:49 am
llokshin (1/26/2009)
But in your opinion there is no way to repair the drive?
No idea. I know databases, not drives
That said, from those errors it appears that you have one...
January 26, 2009 at 11:43 am
If that table is frequently inserted into, then I'd suggest put the cluster on the identity, even if it's never used. That way the cluster will organise the table and...
January 26, 2009 at 11:20 am
llokshin (1/26/2009)
But when our IT ran chckdisk on it it repported 0 errors.
Still, if it's giving errors there's a problem. You don't want to find the problem when the drive...
January 26, 2009 at 11:13 am
Jeff Moden (1/26/2009)
January 26, 2009 at 11:07 am
Ed (1/26/2009)
Does it matter which column is defined in the clustered index?
Yes! Very much so. A bad choice of a cluster can do terrible things to performance. Uniqueindentifier...
January 26, 2009 at 10:22 am
That looks like problems with the IO subsystem. Possibly intermittent right now.
Check the windows event log for anything indicating hardware problems, check the SQL error log, check any logs from...
January 26, 2009 at 9:59 am
Cricketdogger (1/21/2009)
January 26, 2009 at 9:53 am
srihari nandamuri (1/26/2009)
Take corrective action
What kind of corrective action are you proposing?
Dropping indexes that haven't been used since the last server start is not recommended, unless you're very...
January 26, 2009 at 9:52 am
P Jones (1/26/2009)
I also get hot under the collar about bad spelling and grammar - I had a traditional English grammar school education
Just bear in mind that not everyone...
January 26, 2009 at 9:45 am
Has your job been doing full backups, or transaction log backups? In full recovery, you need both.
January 26, 2009 at 9:38 am
Steve Jones - Editor (1/25/2009)
Personally I dislike labeling things bad and good, especially with code since it's a question of where and when things make sense.
If you've read my blog...
January 26, 2009 at 9:36 am
David.Poole (1/26/2009)
I've heard that if an index grows beyond a certain point SQL Server is unable to use it.
May I ask where you heard that from?
As far as I know,...
January 26, 2009 at 9:36 am
Ed (1/26/2009)
IX_sysValidationList is a unique, non-clustered index on the column, ValidationPartyID. Is this index not appropriate for these joins?
Apparently not. Probably because it's not covering. I haven't looked at...
January 26, 2009 at 9:33 am
Viewing 15 posts - 41,431 through 41,445 (of 49,571 total)