Microsoft SQL Server 2005 EMC Datawarehousing Best Practices
Video Title :
Microsoft SQL Server 2005 EMC Datawarehousing Best Practices
Description :
Tune in as EMC's Chad Sakac, senior practice manager for databases and messaging, discusses the challenges of deploying a large database environment. Chad outlines the features and functionalities of SQL Server 2005 and how they were used for Project REAL—a reference architecture built jointly by Microsoft and EMC.
For More Information Visit EMC: http://www.emc.com/solutions/microsoft/sql_server/index.jsp?CMP=SM-YouTube
Views :
14433
Rating :
4.88
Keywords, Tags :
EMC Microsoft SQL Server 2005 Datawarehousing whiteboard chalk talk
Video Length :
4 : 26
Comments :
Yeah, if you want a fast sql when dealing with 100mil records fibre channel drives are the way. But setup is important. I used a mylex extreme raid 3000 and built drives interwoven between the two channels. Each mylex channel is 100 megabyte so gave 200 megabyte by setting up 4 drives in a 8 drive configuration to channal A and the other 4 drives to channel b. You gotta get your indexes right but this setup is mr. speedy.....russ
4 : 26 
Yeah, if you want a fast sql when dealing with 100mil records fibre channel drives are the way. But setup is important. I used a mylex extreme raid 3000 and built drives interwoven between the two channels. Each mylex channel is 100 megabyte so gave 200 megabyte by setting up 4 drives in a 8 drive configuration to channal A and the other 4 drives to channel b. You gotta get your indexes right but this setup is mr. speedy.....russ 
2006©Viduz.com All Rights Reserved. All Video materials brought by YouTube.com