EugeneChiang.com

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:

Database Log File Full

Log records that are not managed correctly will eventually fill up the disk causing no more modifications to the database. Transaction log growth can occur for a few different reasons. Long running transactions, incorrect recovery model configuration and lack of log backups can grow the log. Log truncation frees up space in the log file... » read more

Atlassian Software

https://www.atlassian.com/software Software Description Jira Software Plan, track, and release world-class software with the #1 software development tool used by agile teams. Confluence Spend less time hunting things down and more time getting things done. Organize your work, create documents, and discuss everything in one place. Bitbucket Collaborate on code with inline comments and pull requests.... » read more

Fisheye By Atlassian

https://www.atlassian.com/software/fisheye Search, track, and visualize code changes. Visualize and report on activity and search for commits, files, revisions, or teammates across SVN, Git, Mercurial, CVS and Perforce. Compare View changes with a side-by-side or unified diff tool and link your Jira Software issues directly to diffs, changeset details, or full source. Visualize Get a graphical representation of... » read more

##Table Global Table

#temp tables are available ONLY to the session that created it and are dropped when the session is closed. ##temp tables (global) are available to ALL sessions, but are still dropped when the session that created it is closed and all other references to them are closed.

# vs ## Table

#temp tables are available ONLY to the session that created it and are dropped when the session is closed. ##temp tables (global) are available to ALL sessions, but are still dropped when the session that created it is closed and all other references to them are closed. Local temporary tables are visible only in the... » read more

Send Email with Attachment vis sp_send_dbmail