Viewing 15 posts - 38,506 through 38,520 (of 49,571 total)
600 MB of a 6 GB database isn't much. It's 10% of the data file size. Which, incidentally, is the default autogrow %
June 12, 2009 at 6:56 am
Update usage does not update stats. It updates the space used metadata. That's what's wrong in this case.
Jeff is 100% correct. You need to run updateusage before running that. If...
June 12, 2009 at 6:50 am
RPSql (6/11/2009)
June 11, 2009 at 2:25 pm
mmartin (6/11/2009)
Maybe it is corruption on a non-date field.
If it was corruption the error would not say 'date time conversion'. It would say something like this "SQL Server detected a...
June 11, 2009 at 2:16 pm
RPSql (6/11/2009)
Can you please give detailed description or any article for this for moving table with clustered index, non clustered index and a table without any index...
See my initial reply.
June 11, 2009 at 2:13 pm
To restore to a point in time you need all of the transaction log backups from the full backup up to the point you're restoring to. They are not cumulative.
June 11, 2009 at 2:11 pm
Alberto De Rossi (6/11/2009)
SET XACT_ABORT ON
BEGIN TRY
BEGIN TRAN
CREATE CLUSTERED INDEX ix_TableA_Transfer ON tableA (id) ON [OtherFileGroup]
COMMIT
END TRY
BEGIN CATCH
...
June 11, 2009 at 2:01 pm
RPSql (6/11/2009)
1. Move a table without any index or primary key or constraints
Create a clustered index and specify ON with the new filegroup. Then drop the clustered index
2. Move a...
June 11, 2009 at 1:08 pm
bob.willsie (6/11/2009)
So, my question to the group is: What, if any, is an acceptable error rate for data loss or corruption on SQL Server?
Zero.
Corruption is usually due to hardware problems,...
June 11, 2009 at 11:01 am
acapucion (6/11/2009)
on SQL Server 2008 environment. But we are trying to restore the database...
June 11, 2009 at 10:59 am
That it is. I'm trying to get some clarification as to where that row estimate comes from. It's not from statistics, there's no auto stats events fired and no stats...
June 11, 2009 at 10:33 am
The following should work, but take a backup first (as with all production-type fixes)
Switch the database to simple recovery.
Run a checkpoint
Switch back to full recovery
Take a full backup
Test log backups...
June 11, 2009 at 10:14 am
Joseph Fallon (6/11/2009)
GilaMonster (6/11/2009)
Joseph Fallon (6/11/2009)
When I don't use "SELECT * FROM " the query always uses the covering index. Thanks for the tip Mr Stobbs.
Is the index really covering...
June 11, 2009 at 10:06 am
gmartin (6/11/2009)
I want to "select" without locking things up. SNAPSHOT may be better option, but that's not turned on at the moment.
If you use the default isolation, does that...
June 11, 2009 at 10:00 am
sscddr (6/11/2009)
June 11, 2009 at 9:57 am
Viewing 15 posts - 38,506 through 38,520 (of 49,571 total)