Search Results | SQL Server Performance Forums

100% Fill Factor. When to use it?

Post by: znichter, Sep 28, 2005 in forum: Performance Tuning for DBAs

My bad, didnt see that. Thanks Frank. Zach http://www.sqljunkies.com/WebLog/odds_and_ends/

100% Fill Factor. When to use it?

Post by: znichter, Sep 27, 2005 in forum: Performance Tuning for DBAs

gagilman, why wouldn't you use a 100% fill factor in this situation? Even if these are inserts into the tables, one, the inserts are 6 times a...

Rights necessary to be effective DBA

Post by: znichter, Sep 27, 2005 in forum: General DBA Questions

I'd say it depends on the requirements of the position. Is this a Production DBA position? If they want to monitor and ensure that your server is...

error on sql box

Post by: znichter, Sep 27, 2005 in forum: General DBA Questions

Do you have any more information then that? What is occuring when the error occurs? Is there any information in your system event log, application...

Sql Server Performanc Dual P4

Post by: znichter, Sep 23, 2005 in forum: Performance Tuning for Hardware Configurations

Just curious why you are using RAID 3 on your E drive? I have seen RAID 3 or is it 4 recently only because that is the only supported RAID type for...

Large Query Locks Out Other Transactions

Post by: znichter, Sep 23, 2005 in forum: Performance Tuning for DBAs

May also consider setting the sp_configure max degree of parallelism to n-1 where n is the number of processors on your server. Before you do this...

How to execute multiple SQL Jobs with OSQL?

Post by: znichter, Sep 22, 2005 in forum: General DBA Questions

I have run into this problem myself. The problem that you are running into is that the sp_start_job proc returns a return_status immediately...