Viewing 15 posts - 42,751 through 42,765 (of 49,571 total)
What you can do is just check the size of your log backups. That'll give you an easy way to get the average log volume.
December 1, 2008 at 6:29 am
KPR (12/1/2008)
sorry to reduce it to one sec.
That may not be possible. You're doing a lot of work in there.
What are these?
dbo.fn_ProfileLegalVechile(@ProfCode,@Branch)
dbo.fn_ProfileWareHouse(@ProfCode,@WHCode)
dbo.fn_ProfileCurrency(@ProfCode,@CCYCode)
December 1, 2008 at 6:26 am
KPR (12/1/2008)
Hi Chris, The prev one is the Gilamonster thread I had tried. The below one is yours I had tried.
The suggestions aren't mutually exclusive.
December 1, 2008 at 6:19 am
You could try DBCC SQLPERF(LOGSPACE) for the percentage of the file used. You could also count the rows in fn_dblog(null, null), but that can get intensive and time consuming,...
December 1, 2008 at 5:55 am
KPR (12/1/2008)
Hi Gail,Can you pls give me the syntax for creating index on temp in the proc?
Same syntax as for a regular...
December 1, 2008 at 5:23 am
atulkumar2 (12/1/2008)
Thanks for pointing out my mistake. Yes, we should truncate the log file just before the Database backup.
I prefer to say that the log should not be truncated at...
December 1, 2008 at 5:22 am
I wouldn't know if a 3rd party tool exists. I've never used one.
I've done all my testing with either excel or with the checksum/checksum_agg functions
December 1, 2008 at 5:14 am
Please don't cross post. It just wastes peoples time and fragments replies. There's no need to start a new thread, there are several answers to your original one.
No replies to...
December 1, 2008 at 5:14 am
I've never used a 3rd party tool. Wouldn't know if one exists.
December 1, 2008 at 5:08 am
barb.wendling (12/1/2008)
For example, I did not see the EventClass ID definitions in BoL.
In the 2008 Books Online, the section title is "SQL Server Event Class Reference" and the address...
December 1, 2008 at 5:05 am
atulkumar2 (12/1/2008)
1. I did mention that the command should be used once the Full Backup is taken. This eliminates the chances of any data loss.
Actually, it's the other way round...
December 1, 2008 at 4:56 am
You may want to consider an index on the temp table
I wouldn't normally suggest a wide clustered index, but since this is a temp table, perhaps a clustered index on...
December 1, 2008 at 4:52 am
atulkumar2 (12/1/2008)
BACKUP LOG @Database_Name WITH TRUNCATE_ONLYDBCC SHRINKDATABASE (@Database_Name, 20);
You neglected to mention that the above statements will
1) break the recovery chain of the database by discarding log records, leaving it...
December 1, 2008 at 4:36 am
puneet shadija (12/1/2008)
since we have many threads, which may concurrently try to insert a record to this table, thus I have used this lock to prevent this from happening
Why? What's...
December 1, 2008 at 4:33 am
What's the definition of the login table?
If you run the query that Chirag posted, what do you get?
December 1, 2008 at 4:32 am
Viewing 15 posts - 42,751 through 42,765 (of 49,571 total)