Viewing 15 posts - 4,846 through 4,860 (of 49,571 total)
Try increasing the size of TempDB, you're just running out of space. Put extra files on another drive if necessary, or get a larger drive for it.
Without seeing the formula...
September 2, 2015 at 3:19 am
That's normal. You'll always have intent locks at the table level. Nothing to worry about, it's how SQL's locking process works.
September 2, 2015 at 3:14 am
So 6 then.
In that case, you can try 6, 9 or 12 as maxdop, see which works best for you (calced as 1x, 1.5x and 2x the number of physical...
September 2, 2015 at 3:00 am
I'm going to give you my usual answer.
Analyse, investigate and identify exactly what's happening. Don't guess, you're just going to waste time. Don't try stuff at random, it doesn't work....
September 2, 2015 at 2:52 am
I would suggest you start by reading Books Online, there's lots of details and recommendations there.
September 2, 2015 at 2:50 am
Restore from their last good backup. 😀
Without a backup, pretty close to no options. I can't recall ever having seen a deleted database file recovered and be useful.
What's the exact...
September 2, 2015 at 2:49 am
sqlbaby2 (9/1/2015)
September 2, 2015 at 2:47 am
sqlfriends (9/1/2015)
Can I use a full and differential backup to restore to a point of time?
No. Full and diffs can only be restored to the time which they ran (end...
September 2, 2015 at 2:43 am
EasyBoy (9/1/2015)
Thanks for your prompt response. I understand that we can't limited to growth. But, this is how they implemented tempdb.
Ok, but that doesn't stop you from reconfiguring it correctly
...
September 1, 2015 at 4:32 pm
Then someone else changed something, or you changed something that you didn't think relevant. CheckDB CANNOT have fixed the error you posted.
September 1, 2015 at 4:27 pm
SQLBill (9/1/2015)
Check your code for reindexing....does it use SORT_IN_TEMPDB?
The rebuild starts 20 minutes after the alert, so unless there's a second rebuild job somewhere, it's not from rebuilds.
Could be...
September 1, 2015 at 4:26 pm
Back in SQL 2000 that construct would cause a recompile on every execution, no idea offhand for 2008. Fire up server-side trace or extended events (no GUI in 2008 though)...
September 1, 2015 at 2:53 pm
First fix that growth increment. Nothing should use % growth. Set the growth increment to a sensible size. Second, the limit on the file size means that if something needs...
September 1, 2015 at 2:51 pm
CheckDB cannot fix code problems, and unless the errors being thrown were severity 24, probably did nothing at all.
September 1, 2015 at 1:48 pm
It probably did nothing, since the error was in code and repair can't fix that (short of deallocating pages from the system tables)
Though he said nothing about using the REPAIR_ALLOW_DATA_LOSS...
September 1, 2015 at 1:43 pm
Viewing 15 posts - 4,846 through 4,860 (of 49,571 total)