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

Tag - sql server

sql server

A New SQL Server Client Tool - SQL Operations Studio

34 views   0 comments last modified about 2 months ago

If you have used Visual Studio Code, you probably will also enjoy a new client tool SQL Operations Studio. Currently it is available as preview version and not formally released yet. What is SQL Operations Studio SQL Operations Studio is a data management tool that enables working w...

View detail
sql server

Load Data into HDFS from SQL Server via Sqoop

122 views   0 comments last modified about 3 months ago

This page shows how to import data from SQL Server into Hadoop via Apache Sqoop. Prerequisites Please follow the link below to install Sqoop in your machine if you don’t have one environment ready. ...

View detail
sql server

Connecting Apache Zeppelin to your SQL Server

106 views   0 comments last modified about 3 months ago

This page demonstrates the steps you need to connect to SQL Server in Zeppelin. There are many ways to implement this, for example SQL Server interpreters in GitHub. In this page, I am going to use the JDBC driver to connect to SQL Server instead of using third party interpreters. For authe...

View detail
sql server

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

589 views   0 comments last modified about 9 years ago

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

View detail
sql server

sql 分页存储过程

204 views   0 comments last modified about 10 years ago

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

View detail