Viewing 15 posts - 38,671 through 38,685 (of 49,571 total)
btb1977 (6/5/2009)
June 5, 2009 at 2:22 pm
randall.c.newcomb (6/5/2009)
Do you recall if DBCC INDEXDEFRAG also updates statistics?
It does not.
June 5, 2009 at 12:11 pm
Do you have a backup?
Try using sp_attach_single_file_db
June 5, 2009 at 9:24 am
FreeHansje (6/5/2009)
We have a table with 200+ million rows and growing. This table is so heavily updated that there are no indices placed on it:
Have you tested and proven...
June 5, 2009 at 9:23 am
Circular logging is something that the windows event logs do. The SQL transaction log is not an event or error log. If you're in full recovery and are not managing...
June 5, 2009 at 9:17 am
If you're running against a test server, just clear the proc cache each time before you run it. Otherwise, if you want a recompile for a single query, use OPTION...
June 5, 2009 at 9:11 am
The errors that you've posted are because the RESTORE VERIFY ONLY can't find the file to verify. (Operating system error 2 is file not found)
What's the error that the backup...
June 5, 2009 at 5:43 am
sateesh.kamalakar (6/4/2009)
but still error i am getting in applying the schema name for the two tables.
What error?
June 5, 2009 at 12:21 am
WayneS (6/4/2009)
Paul, I do believe that you found what was going on.
Ok, I was assuming you meant it had changed sometime after the replication was set up.
June 4, 2009 at 10:54 pm
Mayank Khatri (6/4/2009)
Gila,Please look at this MSDN as u might have done many times earlier, u can SHRINK the file using TRUNCATE ONLY that would break the sequence
I see...
June 4, 2009 at 10:51 pm
TRACEY (6/4/2009)
The 12 i think i found on some thread what to check for
Yes, but the check is always for > 12, not <12
June 4, 2009 at 10:45 pm
WayneS (6/2/2009)
Is there anything going on in sql 2005 that would cause these default definitions to be changed? How else could all of these have been changed?
None that I've ever...
June 4, 2009 at 3:42 pm
June 4, 2009 at 3:41 pm
Mayank Khatri (6/4/2009)
If u Truncate the log file using TRUNCATE ONLY(by either shriinking log or by either taking backup)
A shrink does not truncate the log.
June 4, 2009 at 3:38 pm
Viewing 15 posts - 38,671 through 38,685 (of 49,571 total)