SQL Server 最佳实践
发布日期: 2007年11月
作者: Akio Jose
技术评论家: Don Vilen, Fernando Caro, Goldie Chaudhuri, Michael Wang, Sanjay Mishra, Stuart Ozer
当商务增长呈现国际化时，其数据库系统必须能够通过使用Unicode 数据类型，实现在数据表中存储多国语言字符。该白皮书研究的内容是将数据表的列从非Unicode数据类型转为Unicode数据类型以及更改数据库排序规则所花费的时间。并使用这些信息来计算更改大数据表所需的时间。
更多信息，请参考白皮书 The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode
About denny.lee
Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
