The Earth Institute Columbia University

Embedded SQL Programming Guide

To allow an application to retrieve a set of rows, SQL uses a mechanism called a cursor. To help understand the concept of a cursor, assume that the database manager builds a result table to hold all ...
crossjoin.co.uk

Power BI DirectQuery, Gateways And SQL Queries That Return Lots Of Rows

Recently I was working with a customer using DirectQuery mode and where all traffic to the data source had to go through an on-premises data gateway for security reasons. They noticed that report ...
The Earth Institute Columbia University

Call Level Interface Guide and Reference

Rowset starting on next row SQL_FETCH_RELATIVE with FetchOffset set to 1 Line Down Rowset starting on previous row SQL_FETCH_RELATIVE with FetchOffset set to -1 Line Up Rowset starting on a specific ...
GitHub

Less returned rows than expected

I've read documentation and some resources on web but still got something I can't understand. I'm using SQLAlchemy 1.3.10 on a mysql db. When I run this query on dbms I get 219 (unique) rows SELECT ...
Jimmy Bogard

Troubleshooting SQL index performance on varchar columns

18 July, 2012. It was a Wednesday. Doing a deployment last night, I ran into an issue around indexing performance around SQL columns of type varchar. Varchar is the ANSI version of character data – ...