We are going to be migrated to SQL 2008 sooner or later. What things we need to keep in mind while migrating ? To be precise, I am talking about...

Hello Nils, I checked as per your code this weekend and found that using xml datatype is good as it takes approx half space as compared to nvarchar(max).

What would you...

Thanks koen, thats what i was thinking. Wanted to confirm if thats the only best way to do it.

For example, you have table A with approx 1000000000 rows and you have to purge around 10000000 rows on the basis of column LastupdatedDate. Total columns in the table are...

I'm also looking for some hepl on my other post in this section only on Data purging.

Thats cool. Thanks. Now I can see the difference.

Thanks Gila for the clarification.

Tunnel, I will definitely check the video and will give you the feedback.

Ten, thanks for clarifying it in this way. Though it seems sp_spaceused doesnot...

Also what can be the best options to replace them in general ? Also I'm looking for some generalized tips on using datatypes while creating new systems (tables etc)

When are ntext, text and image going to be depricated ? Hope they are in 2008.