All about SQL Server...

sql server hive

Configure a SQL Server Database as Remote Hive Metastore

322   0   about 3 months ago

In one of my previous post, I showed how to configure Apache Hive 3.0.0 in Windows 10. Apache Hive 3.0.0 Installation on Windows 10 Step by Step Guide ...

View detail
sql server python spark pyspark

Connect to SQL Server in Spark (PySpark)

1,191   0   about 4 months ago

Spark is an analytics engine for big data processing. There are various ways to connect to a database in Spark. This page summarizes some of common approaches to connect to SQL Server using Python as programming language. ...

View detail

Querying Teradata and SQL Server - Tutorial 1: The SELECT Statement

35,484   7   about 5 years ago

SELECT is one of the most commonly used statements. In this tutorial, I will cover the following items: Two of the principal query clauses—FROM and SELECT Data Types Built-in functions CASE expressions and variations like ISNULL and COALESCE. * The functio...

View detail

Querying Teradata and SQL Server - Tutorial 2 Filtering and Sorting

3,683   2   about 5 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

3,333   0   about 5 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中的联合主键、聚集索引、非聚集索引

752   0   about 10 years ago


View detail
sql server

sql 分页存储过程

317   0   about 11 years ago


View detail

SQLite Abort due to constraint violation

569   0   about 11 years ago

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

View detail

SQL Server SQL for xml auto 添加根节点

329   0   about 10 years ago


View detail

理解SQL Server中的索引(一)

320   0   about 10 years ago

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

View detail