First thing that comes to mind is substring. You can group by substring(column,1,10) and order by substring(column,11,19) desc

I am not a memory guru by any means but about the only way to clear the buffer pool is to reboot, restart the instance, or run dbcc dropcleanbuffers. ...

Paul, is there a way to run the with repair on a specific file group rather than the entire DB? I have a similiar issue but it is only...

Unique Index Requirement

The SQL Server OLE DB provider requires that a unique index exist on the underlying table for UPDATE or DELETE operations. If no unique index exists on a...

worked for me