Analytics & BI

Data Analytics,Big Data,Data Storage and Business Intelligence.

Subscribe

SQL Server 附加没有日志文件ldf的数据库mdf的方法

482 views 0 comments posted at about 9 years ago

Keywords: how to attach database without log file

View detail

因为数据库正在使用,所以未能获得对数据库的排它访问权 解决办法

118 views 0 comments posted at about 10 years ago

恢复数据库的时候遇到这个错误解决办法

View detail

数据库设计有关范式点滴摘录

109 views 0 comments posted at about 9 years ago

Note1:满足范式要求的数据库设计是结构清晰的,同时可避免数据冗余和操作异常。这并意味着不符合范式要求的设计一定是错误的,在数据库表中存在1:1或1:N关系这种较特殊的情况下,合并导致的不符合范式要求反而是合理的。

View detail

Useful T-SQLs (Part I)

195 views 0 comments posted at about 5 years ago

View detail

Create OLAP Project using SSAS

559 views 0 comments posted at about 4 years ago

View detail

Create ETL Project for Collecting Sales Data using SSIS

807 views 0 comments posted at about 4 years ago

View detail

Create Business Reports using SSRS

438 views 0 comments posted at about 4 years ago

View detail