Analytics & BI

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

Subscribe

[C#] Connect to Teradata Database via .NET Data Provider

3536 views   2 comments last modified about 3 years ago

View detail

Connect to Teradata Virtual Machine Guest from Windows Host

4747 views   16 comments last modified about 3 years ago

View detail

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

2573 views   2 comments last modified about 3 years ago

View detail

Querying Teradata and SQL Server - Tutorial 0: Preparation

2369 views   0 comments last modified about 3 years ago

View detail

SQL Server中的联合主键、聚集索引、非聚集索引

496 views   0 comments last modified about 8 years ago SQL Server

我们都知道在一个表中当需要2列以上才能确定记录的唯一性的时候,就需要用到联合主键,当建立联合主键以后,在查询数据的时候性能就会有很大的提升,不过并不是对联合主键的任何列单独查询的时候性能都会提升,但我们依然可以通过对联合主键中的首列除外的其他列建立非聚集索引来提高性能。关于索引,可以参考我的这篇文章:http://hi.baidu.com/1987raymond/blog/item/a0f7b11062e1330a213f2e26.html

View detail

sql 分页存储过程

156 views   0 comments last modified about 9 years ago SQL Server

个人感觉这个存储过程写得比较的好:转载自:http://www.cnblogs.com/eme/archive/2006/12/19/597275.html

View detail

SQLite Abort due to constraint violation

383 views   0 comments last modified about 9 years ago

今天自己使用SQlite数据库的时候创建了一个表 大致是:Create TABLE [Logs](
[LogID] int PRIMARY KEY NOT NULL
,[LogTitle] varchar(100)
,[LogContent] text
,[LogType] int NOT NULL DEFAULT 0
,[LogAddTime] datetime
);

View detail

SQL Server SQL for xml auto 添加根节点

170 views   0 comments last modified about 9 years ago

今天从数据库中查询出xml,同时添加一个根节点做了如下测试:

View detail

理解SQL Server中的索引(一)

116 views   0 comments last modified about 9 years ago

View detail

Sqlite3.0+.Net2.0实现会话状态存储提供程序

190 views   0 comments last modified about 10 years ago

.net中默认的会话状态是存储在内存中的,当一个网站的用户数量少或者说 同时访问的人数不多的时候可能还没什么,但是一旦用户在线人数过多的时候则会出现瓶颈了,于是本文采用SQlite数据库来实现这个提供程序/// <summary>
    /// Juice网站会话状态数据存储提供类
    /// </summary>
    public sealed class SQLiteStoreProvider : SessionStateStoreProviderBase
    {}

View detail