EugeneChiang.com

Add Column with Collate

Sources: https://dba.stackexchange.com/questions/110911/latin1-general-bin-performance-impact-when-changing-the-database-default-collati

Setting Up Full Text Index

Make sure database is setup for full text index. 2. Create Catalog Database -> Storage -> Full Text Catalogs -> New Full-Text Catalog 3. Define Full-Text Index Database -> Table -> Full-Text Index -> Define Full-Text Index Note: Make sure the table has at least one unique index. 4. Populate Catalog Database -> Table ->... » read more

Full Text Index Search

CONTAINS FREETEXT Sources: https://docs.microsoft.com/en-us/sql/relational-databases/search/full-text-search?view=sql-server-ver15

Populate Full Text Index

Sources: https://docs.microsoft.com/en-us/sql/relational-databases/search/create-and-manage-full-text-indexes?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/search/populate-full-text-indexes?view=sql-server-ver15 https://stackoverflow.com/questions/2727911/how-can-i-know-when-sql-full-text-index-population-is-finished

Add New Identity Column to Existing Table

Create Indexes with Included Columns

By including nonkey columns, you can create nonclustered indexes that cover more queries. This is because the nonkey columns have the following benefits: They can be data types not allowed as index key columns. They are not considered by the Database Engine when calculating the number of index key columns or index key size. An... » read more

Index Seek vs Index Scan (Table Scan)

Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. An scan or table scan is when SQL Server has to scan the data or index pages to find the appropriate records. A seek uses the index to pinpoint the records that are needed to satisfy the query.... » read more

Full Text Index

Full Text Index vs Index Usually, when searching with a normal index, you can search only in a single field, e.g. “find all cities that begin with A” or something like that. Fulltext index allows you to search across multiple columns, e.g. search at once in street, city, province, etc. That might be an advantage... » read more

Database Sequence

You can either use the sequence in the table definition or insert it later when you insert the row. Sequence vs. Identity columns Sequences, different from the identity columns, are not associated with a table. The relationship between the sequence and the table is controlled by applications. In addition, a sequence can be shared across multiple... » read more

Using Powershell to Remove Files via SQL Job

In SQL Job, create the following step Type: PowerShell Run as: SQL Server Agent Service Account Command: