This site uses cookies to deliver our services. By using this site, you acknowledge that you have read and understand our Cookie and Privacy policy. Your use of Kontext website is subject to this policy. Allow Cookies and Dismiss

Analytics & BI

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

Subscribe

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

3994 views   2 comments last modified about 3 years ago

In this post, I will demonstrate how to connect to Teradata database via .NET Data Provider for Teradata using C#. Prerequisites Install the .NET Data Provider for Teradata from the following link: ...

View detail

Connect to Teradata Virtual Machine Guest from Windows Host

5377 views   16 comments last modified about 4 years ago

In my previous posts about Querying Teradata and SQL Server, I logged into the virtual machine graphic interface to manage the database. However, I constantly found it is resource intensive as there is only 4GB memory in my laptop. Instead, I will use text mode to start the virtual machine and co...

View detail

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

2842 views   2 comments last modified about 4 years ago

Tutorial –1 For Teradata developers, if you have no SQL Server installed, please go to the following link to download the SQL Server 2014 Expression Edition. ...

View detail

Querying Teradata and SQL Server - Tutorial 0: Preparation

2633 views   0 comments last modified about 4 years ago

In this serial, I will compare Teradata SQL with T-SQL with samples provided. This is mainly prepared for SQL Server DBAs, Developers and other users to help them quickly master the common used SQLs in Teradata platform. Similar to T-SQL, Teradata SQL implements most part of the ANSI SQL with ext...

View detail
sql server

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

588 views   0 comments last modified about 9 years ago

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

View detail
sql server

sql 分页存储过程

203 views   0 comments last modified about 10 years ago

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

View detail

SQLite Abort due to constraint violation

447 views   0 comments last modified about 10 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 添加根节点

224 views   0 comments last modified about 9 years ago

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

View detail

理解SQL Server中的索引(一)

164 views   0 comments last modified about 9 years ago

对于很多DBA和程序员来说,SQL Server中的索引不是一个陌生的事物,我们甚至每天都在使用它,对于哪些情况下应该创建索引都能一一的道出,不过有可能我们并没有仔细去想它的具体原理,本文将根据我对SQL Server中的索引的理解做一个简单的总结和概述,希望对大家能有所帮助(详细可参考《SQL Server 2005 Implementation and Maintenance》 )。 一,索引的作用 在SQL Server数据库中,当我们需要在大批量比如几亿条数据库中检索或者修改数据的时候,索引能够帮我们快速的找到目标数据。就如同我们要在字典中查找一个字的详细解释,如果...

View detail

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

232 views   0 comments last modified about 11 years ago

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

View detail