I Would like to highlight some points related to the SharePoint 2010 upgrade process: Hardware Compatibility, which means that your SharePoint & SQL Server hardware should be 64bit

Finally the public Beta of SharePoint 2010 is available for download and the good news that we are able to make our SharePoint 2010 Development Environment by using Windows 7 or Windows Vista SP1

CTE introduced in Microsoft SQL Server 2005 that offer a more readable form of the derived table that can be declared once and referenced multiple times in a query and we can used

You can use this approach if you want to audit any logon by user to Sql Server instance but note that the Logon triggers are fired after authentication succeeds but before the user session is

SELECT INTO statement allows you to create a new temporary or permanent table populated with the results of the defined SELECT statement