CREATE TABLE M(
    ID                   D_MATERIAL NOT NULL PRIMARY KEY,
    IS_DELETED           D_BOOLEAN DEFAULT 0 NOT NULL,
     ...
    UPPER_NAME           D_VARCHAR255);

CREATE UNIQUE INDEX M_IDX5 ON M(IS_DELETED,UPPER_NAME,ID)

SRV (Server)	Thu Nov 05 14:18:35 2015
	No free space found in temporary directories
	operating system directive CreateFile failed
	The filename, directory name, or volume label syntax is incorrect.

TempDirectories = Restrict C:\Temp

# ... Once the first specified
# directory has no available space, the engine will switch to the
# next one, and so on.