NTEXT vs NVARCHAR(MAX) in SQL 2005

I recently profiled a sproc that makes heavy use of the TSQL SUBSTRING function (hundreds of thousands of times) to see how it performs on a SQL 2005 database compared to a SQL 2000 database. Much to my surprise the SQL 2005 database performed worse…dramatically worse than SQL 2000. After much researching it turns out … Read more NTEXT vs NVARCHAR(MAX) in SQL 2005

Missing Items in Visual Studio 2005 Menu

I noticed some missing menu items in the VS2005 (like clean, rebuild, and many others) but i continued by using the commands from other locations; until I got stucked!  I wanted to export a form as a template but the Export was not available in the File menu. The details of my environment are: WIN … Read more Missing Items in Visual Studio 2005 Menu