This one of the very interesting article I read regarding SQL Server 2005 Storage. Please refer original article at MS TechNet here.
Reference : Pinal Dave (http://blog.SQLAuthority.com) , MS TechNet .
Question for you. What’s the best way to exploit MAXDOP on hyper-threaded server (4 CPUs)? I want to use all the resources available without worrying about deadlocks. I am processing millions of records (job executing a stored procedure).
Please share any comments you have …