Viewing 11 posts - 1 through 11 (of 11 total)
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! 😀
February 20, 2012 at 10:38 am
Thanks for the info Gail. Just double checking to be completely sure 🙂
October 24, 2011 at 8:35 pm
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...
October 24, 2011 at 2:18 pm
Gotta say thanks once again for going above and beyond Jack. Appreciate that you ran the tests to confirm the results 😀
October 7, 2011 at 9:36 pm
Thanks for confirming that for me Jack. Just wanted to double check before I use this feature.
October 7, 2011 at 9:24 pm
Thank you everyone very much for your expertise and suggestions. I really do appreciate it. 😉
I will take all your advice into consideration.
July 18, 2011 at 4:38 pm
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...
July 18, 2011 at 12:13 pm
TheSQLGuru (7/11/2011)I would go with RAID1 for OS, binaries and all tlogs. Then RAID10 (or raid 5) for other 4 disks for all data files.
Thanks for the suggestion. One...
July 17, 2011 at 12:16 am
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...
July 10, 2011 at 3:58 pm
Yeah thats a good blog indeed. Lots of visuals.
Well guys, I think that does it, thank you both for your help 🙂
July 4, 2011 at 3:22 pm
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...
July 4, 2011 at 12:06 pm