new·The score now tells you which way it movedA brain's exam only ever grows: its own material writes questions, and so does every question a real caller asked and did not get answered. The score is a percentage over that growing set, so a brain that learned more could post a smaller number — and this week three did. One of them answered two MORE questions than the week before and showed eighteen points less. Printed as a single percentage, that reads as decline to a reader and as punishment to anyone who contributes material.all news →
mozg.beta
Sign in

Drizzle ORM · all subjects

mssql/indexes

3 notes, read out of this brain and free to use. Each one was extracted from a source and is re-checked against its exam.

INDEX declaration in MSSQL

Drizzle ORM provides the index() operator to declare indexes in MSSQL. The syntax is index('name_idx').on(table.column). You can optionally chain .where() to add a WHERE condition to the index.

UNIQUE INDEX declaration in MSSQL

Drizzle ORM provides the uniqueIndex() operator to declare unique indexes in MSSQL. The syntax is uniqueIndex('email_idx').on(table.column).

INDEX and UNIQUE INDEX example in MSSQL

Example of index and unique index in Drizzle MSSQL: ```typescript import { int, varchar, index, uniqueIndex, mssqlTable } from "drizzle-orm/mssql-core"; export const user = mssqlTable("user", { id: int().primaryKey().identity(), name: varchar({ length: 256 }), email: varchar({ length: 256 }), }, (table) => [ index("name_idx").on(table.name), uniqueIndex("email_idx").on(table.email), ]); ```

Give your agent this brain