Viewing 15 posts - 37,546 through 37,560 (of 49,566 total)
You can split them out if you want, up to you. If you chose to do so, just replace the AssessmentHeading column with an assessmentHeadingID and have another table like...
July 21, 2009 at 5:55 am
You can kill the shrink, it's not harmful to do so and it'll kill fairly quickly. However we need to find what's running that shrink and remove it.
Do you have...
July 21, 2009 at 5:54 am
What recovery model is your database in? I'm guessing simple. Logs can only be backed up if the DB is in full or bulk-logged recovery.
July 21, 2009 at 2:58 am
CheckDB won't repair these, they're damaged statsblobs in sysindexes. There's a chance that we can repair them manually, if it doesn't work, you're going to have to either restore from...
July 21, 2009 at 2:55 am
rvje (7/21/2009)
July 21, 2009 at 2:08 am
Can you post the entire query?
July 21, 2009 at 2:02 am
Be patient. You posted that just before 5pm my time yesterday. I'll take a look when I have several minutes to spend on it exclusively.
July 21, 2009 at 2:02 am
Can you run the following and post the full results?
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
July 21, 2009 at 1:57 am
awp (7/20/2009)
July 21, 2009 at 1:50 am
Before you shrink tempDB, read through this: http://support.microsoft.com/kb/307487
July 20, 2009 at 1:59 pm
mahesh.vsp (7/20/2009)
upto my knowledge, in SIMPLE recovery model, the T-log gets truncated whenever CKPT occurs or whenever 70% of the T-log is full.How would this allow replication in Simple model?????????
http://sqlinthewild.co.za/index.php/2008/12/05/a-new-sql-myth/
July 20, 2009 at 1:56 pm
I suspect I know who's teaching it (will PM you). If it is the class will be awesome. Regarding PASS, you can buy the DVD even if you don't attend...
July 20, 2009 at 1:44 pm
rvje (7/20/2009)
They seem rather small, about 2-60 pages.
Due to the way pages are allocated for small indexes/tables, very small indexes don't defrag properly. It's not a concern. Fragmentation only starts...
July 20, 2009 at 1:42 pm
If the question was urgent (as you stated), you should have checked Books Online. It's faster than waiting for someone to reply.
Books Online:
OFFLINE
The database is closed, shut down cleanly, and...
July 20, 2009 at 10:01 am
Viewing 15 posts - 37,546 through 37,560 (of 49,566 total)