The reason for this is we have very complex query with huge Where clause. What I suspect is that SQL Server spends a lot more time to build execution plan...

In SSMS/Database/Properties/Filegroups I found my FileGroup, it has 0 under Files column. I pressed Remove button and then OK, but got a message :

Drop failed for FileGroup 'lpad_20090124'. (Microsoft.SqlServer Smo)

Additional...

select nos, max(date1)

from

(

select nos, date1 from #temp union all

select nos, date2 from #temp union all

select nos, date3 from #temp

)t

group by nos

But my problem is that I could not find any file for the filegroup in the first place.

We actually used to have it, David. But there are at least two problems we faced with such kind of allocation.

1. Databases in dev and in prod have the same...

Hi Steve,

The rates you posted look really great ! However I checked Dice.com for Denver area and what I've found was mostly $65-75/hour.

Or maybe Dice is not the best...

8 weeks of vacation ? Every one year ?? What is name of this company, please !

1. Perfmon

2. Profiler

sys.columns