SQL Server
浪菜叶
数据仓库实践者
展开
-
Flatten hierarchyid in SQL Server 2008
在SQL Server 2008中引入了hierarchyid来处理树状结构。下面简单就以AdventureWorks(无hierarchyid)和AdventureWorks2008(有hierarchyid)里的HumanResources.Employee为例,来说明一下在新的hierarchyid中如何进行flat化的dimension抽取。AdventureWorks是微软为SQL原创 2010-05-21 10:06:00 · 469 阅读 · 0 评论 -
卸载SQL Server 2008,不断要求重启电脑
<br />在添加删除程序里卸载SQL Server 2008时,无论是否刚重新启动过,都要求重启“a computer restart is required sql server” 以至于无法继续。<br />Solution: delete all values under "HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager/PendingFileRenameOperations",然后re-run一下,restar原创 2010-12-16 16:20:00 · 6009 阅读 · 1 评论