Latest Additions on sql

Visual web developer express 2010 install over existing sql server 2005

Posted 08 October 2012 - Category SQL Sub Category General

The installer for VWD 2010 will not install when there is an exisitng sql server 2005. The following workaround will solve this.

Recompile all stored procedures, user-defined functions and views in the database

Posted 01 March 2011 - Category SQL Sub Category Database State

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.

Problem with creating an index on a large table causes timeout

Posted 30 June 2010 - Category SQL Sub Category Enterprise Manager

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.

Change SQL Server bit field to the opposite value using ~

Posted 13 April 2010 - Category SQL Sub Category Language TSQL

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

UDF to work out a date value from a string version held in different formats

Posted 24 March 2010 - Category SQL Sub Category Date And Time

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.

Choose from the right hand menu to see full lists within subcategories