Our data layer project has the usual hundreds of generated files. Several months ago that was no issue, but over the last month or so things began to get slower and slower. My first attempt to get back to reasonable performance was to break the data project out of my main solution. For the last few weeks even the separate project was hard to work with. I turned off Ankh, the Subversion add-in for Visual Studio. That seemed to help a bit. I even tried turning off Norton when loading the project but...

What I think I saw - So there I was happily loading a DECLAREd variable with a SELECT statement in a SQL Server SProc. The variable was declared like this: DECLARE @myVar decimal The value I was retrieving was decimal - precision 19.2 - but what I got in my decimal variable was integer. So I changed to a more specific definition like: DECLARE @myVar decimal(19,2) And then got what I expected, a decimal value. So I’m guessing the “decimal” declaration must default to something like...