View Single Post
Banana
is the next Chiquita
 
Join Date: Feb 2005
 
2009-03-05, 20:26

The test database I'm developing against is >20 GB. Not quite big, as it's just sample data I use for testing the prototypes that eventually becomes stored procedures for the current project I'm working on.

Believe me, I'm sorely missing MySQL's fabulous memory engine as SQL Server has no similar thing (yes, it does have temporary table but they get written to HD anyway. How assine is that?)

As for indexing, I make it a point to do full table scan for everything I do. It's much more fun. You should try it sometimes.
Yes, though there are times where I'm adjusting the indexes, figuring out if it helps or not but that's expected as part of development.
  quote