I appreciate the answers guys, like the detailed explanations you posted Ed. Really shed some light onto the subject, some things I will definitely keep in mind. Thread completed! 😀

Thanks for the info Gail. Just double checking to be completely sure 🙂

Thanks for the advice Gail. When I ran a simple SELECT *, it only returned 980 records, stopped due to I:O error, but when repaired actually held ~5200 records. Doing...

Gotta say thanks once again for going above and beyond Jack. Appreciate that you ran the tests to confirm the results 😀

Thanks for confirming that for me Jack. Just wanted to double check before I use this feature.

Thank you everyone very much for your expertise and suggestions. I really do appreciate it. 😉

I will take all your advice into consideration.

Yes we actively use tempdb's. As for recovery model, we will be using Simple.

I would like a further explanation of why I should keep the tempdb on the RAID10 array...

Thanks for the suggestion. One...

Hi Everyone,

Thank you for your responses. Sadly the server only has 6 drive bays maximum, and we are on a budget, so buying SAS or anything above that is kind...

Yeah thats a good blog indeed. Lots of visuals.

Well guys, I think that does it, thank you both for your help 🙂

Thank you for your responses. Really detailed info you gave me Eddie, just what I was looking for 😉

Came across these benchmarks, seems like the 64KB will produce the best...