Tuesday, March 27, 2012. I have a problem with collation in SQLServer database. When I execute query SELECT field FROM table ORDER BY field, return set is. Why does value 7-1 is placed between values 71 and 72 and not after 7 1. Is there any way to tell SQLServer to set order of returned resultset in the.

Tuesday, March 27, 2012. The MDF file is 800 MB but the LDF file is 5 GB. But this does not seems to reduce the mdf or ldf filesize. What I did is detach the database, delete the ldf file, re-attach the. Database to create a new ldf file. If I do not do so, the application cannot. Because the ldf file is too huge and it takes ages to commit a. Should I restrict the log file size to a specific filesize.

Thursday, March 29, 2012. Is there a reliable white paper for clustering sql2k on win2k3. Is there a reliable white paper for clustering sql2k on win2k3. Already got the OS clustered. Does anyone have any updated information on.

Thursday, March 29, 2012. Combining XML Files using SSIS or T-SQL etc. Peter DeBetta, MVP - SQL Server. How can I combine all my xml files so it can be processed by SSIS in order. That I may create a table containing the imported xml files? Could you please explain more in detail. Thank you in advance for your assistance. Peter DeBetta, MVP - SQL Server.