May 29, 2003 at 9:34 am
Why does the Transaction Log change throughtout the day. Somtimes its small other times its alot bigger. I don't understand what causes it.
May 29, 2003 at 10:42 am
- if you use temporary tables for your SQL or SP, if those temp tables are indexed and you have to manipulate large amouns of data
- if you use order by, group by against large tables.
- look at the index creation, check your query plans
...there are only some of them.Check your users SQL and the APP's.
May 29, 2003 at 10:53 am
hey, yeah i think we do. what does SP stand for?
May 29, 2003 at 11:46 am
Stored Procedures
🙂
June 5, 2003 at 8:16 am
I am interested in Bulkloading and translating without using the transaction log. it's always a truncate rebuild process, so transaction integrity is not an issue...rudimentary DW. Is there a way to stop using the log for this database? It's set to 'SIMPLE', but is there anything else I can do?
June 5, 2003 at 10:05 am
If you don't care about the log file, you may want to schedule a job every often to truncate the log
use <Database_Name>
go
dbcc shrinkfile (Log_Filename, 300)
go
backup log Database_Name with no_log
go
Shas3
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply