InfoWorld

The best new features in MariaDB

The open source MySQL spin-off has steadily added features all its own. Here are five good reasons to switch to MariaDB.
GitHub

RESUMABLE in ALTER TABLE (Transact-SQL) reports not valid option

static void Main(string[] args) { var script = @" ALTER TABLE table1 ADD CONSTRAINT PK_Constrain PRIMARY KEY CLUSTERED (a) WITH (ONLINE = ON, MAXDOP = 2, RESUMABLE = ON, MAX_DURATION = 240); "; var ...
GitHub

SQL: ALTER TABLE users ALTER COLUMN password SET NOT NULL

SQL: ALTER TABLE users ALTER COLUMN password SET NOT NULL #306 New issue Closed KikeVen ...
Houston Chronicle

How to Reindex SQL Tables

The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...
Ars Technica

problems with SQL alter table command

i need some help with a SQL alter command. i am trying to add a field to my table, but when i do the field is filled with null in any existing rows. how can i just make it fill blank like the value ...