Viewing 15 posts - 10,816 through 10,830 (of 49,566 total)
If it's leaving a transaction open, I suspect the procedure's failing somewhere or has something else wrong.
November 27, 2013 at 12:02 am
None of those are promotions from DBA, they're just alternate career paths. To move DBA to one of those would be a side-ways step, not upward.
November 26, 2013 at 10:12 pm
JayK (11/26/2013)
Can anyone explain to me what happened in the TL when I changed the mode from Simple to Full to allow me to shrink it down?
I'm going to go...
November 26, 2013 at 10:11 pm
mJai (11/26/2013)
Oldest active transaction:
SPID (server...
November 26, 2013 at 9:58 pm
You'll definitely need to rebuild the clustered index to release the free space into the data file for reuse by other tables, may need to run DBCC CleanTable as well
November 26, 2013 at 11:19 am
DBCC CheckIdent
Look in Books Online for the exact syntax and explanation of how it works
November 26, 2013 at 11:18 am
It says locks, so one would assume it has something to do with locks.
As I said above, the 'average wait time for an instance' is useless. You need to investigate,...
November 26, 2013 at 8:15 am
Depends on what the waits are for. Average wait time by itself is useless, to even begin to start you need to know what waits and what the tool considers...
November 26, 2013 at 7:58 am
About fixing metadata, I'm not discussing about the complexity of parsing the files and checking each page's content and I really don't want to go this way. When I said...
November 26, 2013 at 7:55 am
7% reserved is low for a server this size. The OS needs memory to map and manage memory. I'd go with Jonathan's recommendations (in book and blog post referenced above)...
November 26, 2013 at 7:11 am
Zksod (11/26/2013)
I figure this is sorted... but just check that auto close is not set to ON.
Autoclose doesn't set the database to the OFFLINE state. A database closed by Auto_Close...
November 26, 2013 at 6:48 am
I generally recommend leaving min server memory at 0 unless there's a good reason otherwise. Good reasons may include over-committed virtual machines and multi-instance clusters where it is possible for...
November 26, 2013 at 6:45 am
Most of them don't do what they promise. I personally wouldn't use any.
As for what you use when repair doesn't work - restore. Restore from backup. Emergency mode repair is...
November 26, 2013 at 6:42 am
Viewing 15 posts - 10,816 through 10,830 (of 49,566 total)