随笔分类 -  数据库&sql

数据库从sql 2000迁移到SQL 2005遇到的问题
摘要：数据库2000迁移到2005遇到的问题一、SQL Server 2005“备份集中的数据库备份与现有的数据库不同”还原数据库的时候可能会遇到这个问题，在勾选了“选项”->“覆盖现有数据库”就可以解决。二、SQl Server2005目录查找失败,出现操作系统错误..在还原数据库的时候在bak文件中存储了原始数据库的存储路... 阅读全文
posted @ 2010-03-16 10:43 yangjun 阅读(676) 评论(0) 推荐(0)
Top 10 steps to optimize data access in SQL Server. Part II
摘要：IntroductionRemember we ware in a mission? Our mission was to optimize the performance of an SQL Server database. We had an application that was built on top of that database. The application was work... 阅读全文
posted @ 2009-04-21 09:20 yangjun 阅读(531) 评论(0) 推荐(0)