SQL Server Overall

All about SQL Server...

[SQL Server 2012] 使用自带功能简化SQL

641 views   0 comments last modified about 5 years ago

View detail

将远程 Sql Server 服务器上的数据库备份到本地的方法

428 views   0 comments last modified about 9 years ago

首先,必须知道数据库服务器的地址(IP),连接用户名和密码、其次,可以按照下面几种方式进行:

View detail

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

543 views   0 comments last modified about 9 years ago

Keywords: how to attach database without log file

View detail

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

132 views   0 comments last modified about 10 years ago

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

View detail

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

117 views   0 comments last modified about 9 years ago

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

View detail

Useful T-SQLs (Part I)

210 views   0 comments last modified about 5 years ago

View detail

Working with SQL Server Compact 4.0 using Entity Framework 6 and ADO.NET

9525 views   0 comments last modified about 4 years ago

View detail

Create OLAP Project using SSAS

641 views   0 comments last modified about 4 years ago

View detail

Create ETL Project for Collecting Sales Data using SSIS

1016 views   0 comments last modified about 4 years ago

View detail