New posts in Index

Large hexadecimal PRIMARY KEY - how to index substrings of the PK field?

SQLServer - treat table as index

Clustered Index fragmentation vs Index with Included columns fragmentation

Using a filtered index when setting a variable

Are multiple indexes on MYSQL table reason for slow UPDATES and INSERTS?

How can I set a column to NOT NULL without locking the table during a table scan?

ALTER VIEW drops Index from View

Creating an Index that is not used by a (SELECT) query reduces performance of that query

SQL Server - Select most recent record from each group when performance is critical

SQL Server keep reverting to inefficient plan (Clustered index Scan) once a week