SqlServer-QA.net

I have seen many newbies asking ''How do I sort the numbers stored in varchar columns?'' Here are some methods declare @t table(data varchar(15)) insert into @tselect '6134' union allselect '144' union allselect '7345' union allselect '109812' union allselect '100074'union allselect '1290' union allselect '45764' --Method 1 select data from ...

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information you need to consider that one of the reason behind slow indexes process or rebuilding ...