Latest Additions on sql

This script will recompile all stored procedures, user-defined functions and views in the database. This will refresh stored procedures execution plans stored in memory in order to reflect recent schema changes. Previous structures for instance in table functions can be held which will not represent new table structures correctly. So as a process it is good to run this when deploying new versions of the database.

If you are performing a long processing operation such as creating an index on a large table, you may find that enterprise manager times out.

In sql server you can flip the bit field value by using the ~ (tilde) operator

A string version of date can be entered differently which makes the translation to a proper date type difficult. This function will do this for you.

This can prove annoying when the system assumes mm/dd/yyyy usa format as opposed to dd/mm/yyyy uk format.