refer below. It's somewhere in there

http://www.sql-server-performance.com/best_sql_server_performance_tips.asp

-----Original Message-----
From: Harris, Heather [mailto:[Email Address Removed] 28/04/2004 17:05
To: LazyDBA.com Discussion
Subject: RE: One more question!!!


Explain this statement. I haven't seen any issues w/ this setting thus far.

-----Original Message-----
From: Crosby, Terry [mailto:[Email Address Removed] Wednesday, April 28, 2004 10:49 AM
To: LazyDBA.com Discussion
Subject: RE: One more question!!!


Be wary of auto shrink and the overhead involved with auto shrink and auto
grow.

-----Original Message-----
From: Harris, Heather [mailto:[Email Address Removed]
Sent: Wednesday, April 28, 2004 9:07 AM
To: LazyDBA.com Discussion
Subject: RE: One more question!!!

You'll also want to make sure that on the Database Properties, Options tab,
you select the Auto Shrink option. When your database is in Simple Recovery
mode, the Auto Shrink references the Transaction Log.

Heather Harris
Application Consultant III
Kronos Incorporated - Labor Analytics Division
E-mail:[Email Address Removed] <mailto:[Email Address Removed] (813) 287-0555
Fax: (813) 289-4135
www.kronos.com <http://www.kronos.com/>
Improving the Performance of People and Business(tm)

-----Original Message-----
From: Ravi Verma [mailto:[Email Address Removed] Wednesday, April 28, 2004 4:00 AM
To: LazyDBA.com Discussion
Subject: One more question!!!


Hi Gurus,
One more question.

How to schedule the process of automatic truncating and shirnking the log
file.
Please suggest.
Ravi Verma
Team Leader eCRM
Cyber Futuristics (I) Pvt.Ltd.
----------------------------------------------------------------------------
--
D-61,2nd Floor,Shiv Heera Path, C-Scheme,Jaipur-302001
Ph:91-141-2366498, 2368166, 2374143 Ext # 24
Website : www.go4customer.com
EMail : [Email Address Removed] , [Email Address Removed]
----------------------------------------------------------------------------
--

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page