Compare just the date part of a date object ignoring the time

Quick way to work out the lines of code written in your visual studio solution using the search facility.

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.

This makes the cursor different when over some text.

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.

When using ajax aspx pages use RegisterStartupScript. Using techniques such as response.write to add scripts on an event postback will not render the page correctly.

'No files were found to look in. Find was stopped in progress' can appear when doing a find in visual studio. This is a bug as the find in question should return results.

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

This error occured when publishing a site but was working ok inside visual studio usage. The solution in this case is simple.

When entering a currency value this extra use of the RegularExpressionValidator stops the entry of a '.' and thus prevents pence form being entered.