SQL Datatypes

I was wondering about all the data types that are available during table creation in SQL server 2008 R2 Express. After searching (not very hard) I found this from Personal Notes of Pinal Dave 
“Yes, VARCHAR(MAX) is big enough to accommodate TEXT field. TEXT, NTEXT and IMAGE data types of SQL Server 2000 will be deprecated in future version of SQL Server, SQL Server 2005 provides backward compatibility to data types but it is recommanded to use new data types which are VARHCAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX).”


An important piece of information don't you think.

SQL Server 2008 R2 mdf nightmare

Attaching a Visual Web Developer 2010 Express SQL MDF to SQL Server 2008 R2 is not a good idea.
I was looking for a way to draw Entity Relationship diagrams, so I decided to use the SQL server management studio Diagram functionality. So I thought I'd be clever and attach the .mdf to my 2008 R2 in the studio.
While I was arranging the diagrams I realized that I needed to quickly add a primary key to one of the tables... So I did and saved.
When I was done I tried running the project. What a nightmare. The 2008 R2 server upgraded my mdf and so now I could not connect. The error said that the database file had been upgraded and that there was no downgrade path.
Then I decided to restore from a backup from yesterday. Nightmare 2. The .mdf was being held by a sql server running on my machine. So searching the web I found that stopping all the server instances, might help. NOT.
I ended trying to delete the file. No luck. Then I chose to use Unlocker 1.9.1 The file would not unlock. Fortunately, the unlocker gave me the option to delete the files on the next re-boot.
Finally, that worked and I could continue working.

The nightmare begins...

Lets start with where I'm calling from. I don't know everything, and sometimes I
feel like I know less than that. Everything I know, I have had to learn the hard
way; trial and error and error and error. By day I go by "Senior Specialist Application Consultant" and by night I go by "...another brick wall". It seems that everything I attempt first involves a steep learning curve and then the lesson "Don't try that again". So I decided to share my experiences with others.
SOFTWARE
My favorite software toolkit:

NOTEPAD++(Text Editor)	Here
Filezilla (FTP Client)	Here
SQL server 2008 R2 (Database starter pack)	Here
Visual Studio 2010 Express All-in-One ISO (Development starter pack)	Here
Open Office Org (Office suite)	Here
StartUML (UML designer)	Here
Take Ownership (Tool for windows, this helps)	Here
FireFox (Web Browser)	Here

---