GitHub

call-sqlcolumns-on-a-table-with-sparse-columns.md

This sample shows how to call SQLColumns on a table with sparse columns that were defined by using ODBC in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md ...
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 – ...
GitHub

tables_with_incrementing_columns.sql

-- Finds tables with incrementing column names (for example, contact1, contact2, contact3), -- which indicates de-normalization that could be replaced with a separate child table and a foreign key. -- ...
Simon Fraser University

CREATE TABLE Statement

is the name for the constraint being specified. The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form ...