Viewing 15 posts - 36,856 through 36,870 (of 49,563 total)
Please read through this - Managing Transaction Logs[/url]
and don't even consider deleting the log. It's asking for lots of trouble.
August 25, 2009 at 3:05 am
That's the standard database startup messages. SQL will always print those in the log when it brings a DB online and opens it.
The things that will cause that are:
autoclose
the...
August 25, 2009 at 3:02 am
t-jonat (8/25/2009)
WITH REPLACE, NORECOVERY and MOVE didn't work either, although I don't remember the exact error message and im not on that machine right now.
To offer any useful help, I'll...
August 25, 2009 at 2:59 am
Paul Randal (8/24/2009)
August 25, 2009 at 2:53 am
Can you post the actual messages from the error log? (cut and paste). That's not a standard CheckDB message, so I'm going to assume you're paraphrasing.
If it says something like
CHECKDB...
August 24, 2009 at 3:33 pm
jan.tilburgh (8/24/2009)
insert into test
(
testTIMESTAMP,
testVALUE
)
select
@newTimeStamp,
testValue + newValue
from test
order by
testtimestamp desc
If there are 4 rows in test at the point where that insert runs, how many rows should it insert? Currently it...
August 24, 2009 at 2:58 pm
Is the distinct really necessary? If there's no where clause, nothing limiting rows, you're probably going to get hash joins (that use TempDB) and the sort for the distinct will...
August 24, 2009 at 2:55 pm
Krasavita (8/24/2009)
1.The only way in 2000 to run optimization job:is offline?
I can't recall what settings the 2000 maint plan uses (if it uses) to decide index reorg vs index rebuild....
August 24, 2009 at 9:53 am
In management studio, press F7. Select all the tables that you want to delete, press the delete key.
August 24, 2009 at 9:02 am
Some advice not directly related. Tell your colleague that it's better to own up to a mistake than for it to be discovered and for the boss to have to...
August 24, 2009 at 8:45 am
Did you do what the error message said? If not, please run the following and post the full output
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have...
August 24, 2009 at 8:13 am
russ (8/24/2009)
The issue I am concerned with is table changes first go to the log file then the data file.
Mostly correct. More correct would be to say that the changes...
August 24, 2009 at 8:06 am
Krasavita (8/24/2009)
It is 2000 edition
Then why is it posted in a sQL 2005 forum?
it locks all of the tables in the database.Reorginizes data and index pages.Change persantage to 10...
August 24, 2009 at 8:04 am
t-jonat (8/19/2009)
August 24, 2009 at 12:02 am
The best way to avoid deadlocks are optimal code and effective indexes.
If you're getting deadlocks, please can you post table structure, the two queries involved and the deadlock graph.
Switch traceflag...
August 23, 2009 at 11:59 pm
Viewing 15 posts - 36,856 through 36,870 (of 49,563 total)