Home / SAP SQL Anywhere (page 2)

SAP SQL Anywhere

Introducing the SQL Anywhere Wiki

Did you know that SQL Anywhere has an associated Wiki site? It’s true! Check it out here:      http://wiki.scn.sap.com/wiki/display/SQLANY/ Why have a SQL Anywhere Wiki site? The SQL Anywhere Wiki site is intended to complement the existing SQL Anywhere Documentation ( http://dcx.sap.com/ ) by providing walkthroughs, examples, and explanations of …

Read More »

From the Archives: Analyzing Clustered Indexes

In this post, originally written by Glenn Paulley and posted to sybase.com in September of 2010, Glenn talks about how the optimizer takes advantage of clustered indices and describes some of the statistics associated with clustered indices.  Understanding this information can help you to determine whether or not a declared …

Read More »

From the Archives: Keywords and Upgrades

In this post, originally written by Glenn Paulley and posted to sybase.com in April of 2010, Glenn talks about how keywords are recognized by the SQL Anywhere parser. Each new SQL Anywhere release brings additional SQL functionality, some resulting from enhancements to the SQL standard, and some resulting from our …

Read More »

From the Archives: Mixing SQL Dialects

In this post, originally written by Glenn Paulley and posted to sybase.com in May of 2009, Glenn talks about SQL Anywhere’s built-in support for 2 dialects of SQL: TSQL and Watcom SQL, and how mixing dialects can potentially cause problems within your stored procedures. In November 1995 we launched the …

Read More »

SQL Anywhere 2014 Technical Summit

Early in November, the 2014 SQL Anywhere Technical Summit was hosted in Waterloo, Ontario, Canada. The invitation was open to any SQL Anywhere customers to attend, and we had representatives from 30 different companies join us for 2.5 days of technical discussions with the SQL Anywhere engineering team. This event …

Read More »

SQL Anywhere Publishes New TPC-C Benchmark Results

This morning the SQL Anywhere team published for review a new TPC-C Benchmark Result, which would place SQL Anywhere at number 1 in the top price/performance results for TPC-C. Of note, the benchmark: used a SQL Anywhere database 750GB in size used 90000 connections provided a throughput rate of 112,890 …

Read More »

SQL Anywhere and Pi – opening doors

Background Accsys develops enterprise Access Control and Time & Attendance solutions.  Part of our offering, is a mobile app (iOS and Android) that uses geo-fencing to allow employees to clock into work areas defined by their GPS coordinates.  Although the core of our solution revolves around biometric identification (fingerprint, face-recognition, …

Read More »

Importing data from Microsoft Excel

In this post, originally written by Glenn Paulley and posted to sybase.com in November of 2009, Glenn talks about importing data from Microsoft Excel into a SQL Anywhere database. One way to import data from a Microsoft Excel spreadsheet into a SQL Anywhere database is via the DBISQL INPUT statement. …

Read More »

From the Archives: Disk failures in the real world

In this post, originally written by Glenn Paulley and posted to sybase.com in October of 2009, Glenn talks about traditional hard drive reliability. An ars technica article from earlier this year indicates that not much has changed in terms of failure rates since this post was written.  Of course, taking …

Read More »

From the Archives: Using RowGenerator – part deux

In this post, originally written by Glenn Paulley and posted to sybase.com in October of 2009, Glenn talks about how one can simulate the behaviour of the RowGenerator table and the sa_rowgenerator(…) function using standard SQL. After posting my recent article on the use of the RowGenerator system table, I …

Read More »

Using Amazon’s Web Services SDK Inside SQL Anywhere

One of my colleagues, Joyce Liu, recently posted a document that explains how to create a stored procedure that automatically copies a database backup to Amazon S3.  If you haven’t seen this document, here’s its URL: http://scn.sap.com/docs/DOC-55978. Cloud computing is a hot topic these days and that was part of …

Read More »

From the Archives: Using RowGenerator

In this post, originally written by Glenn Paulley and posted to sybase.com in September of 2009, Glenn talks about the use of the built-in RowGenerator table. Join conditions that involve only inequality conditions are rare, primarily because most joins are between tables related through referential integrity constraints. In doing some …

Read More »

From the Archives: Benchmarks and measurement bias

In this post, originally written by Glenn Paulley and posted to sybase.com in March of 2009, Glenn talks about the perils of simplistic benchmarks and focuses specifically on measurement bias. In the past few weeks I’ve witnessed a number of published performance analyses, both with and without SQL Anywhere. By …

Read More »