日経クロステック

行サイズの「8Kバイト制限」を緩和する

先に公開した記事「SQL Serverの基本ストレージ・モデルとディスク・スペース管理手法」では，SQL Serverの各テーブル(またはインデックス)に格納するデータの形式には三つのタイプがあることを説明した。通常の行内(IN_ROW)データ，ラージ・オブジェクト(LOB ...
Ars Technica

SQL: CHAR or VARCHAR (again...)

Another one of these choices... to go with a char or varchar for a field. Not really an issue with space since we are only looking at a couple of thousand records or so but just wondering what the ...
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

SQL Server VARCHAR(MAX) on reflection can't compile or print

With SQL Server, you can create columns of type VARCHAR(MAX). This is the modern rendition of NTEXT or TEXT, and SQL Alchemy translates String() into VARCHAR(MAX ...
GitHub

SQL Server bulk insert doesn't allow inserting varchar column values longer than 1 character

For SQL Server, a runtime exception is thrown and you cannot save changes on a DbContext when trying to insert more than one of the same type of entity if that entity has an underlying varchar column ...
Ars Technica

ODBC Truncation errors: Filemaker reading SQL varchar

I have an MS SQL 2005 database, and a FileMaker 10 client accessing it via ODBC (SQL Native Client) The data I am trying to import is (varchar(max), null). I have no problem importing (varchar(64), ...