65 karma · joined January 24, 2008
Partion switching is also fast. Say you have a summary table that is rolled up by month, but you want to recalculate the summaries every so often. You can build a month into a new table and then switch the new table for a partition in the summary table.
https://blogs.msdn.microsoft.com/psssql/2010/09/01/slow-quer...
CTRL + V
CTRL
TI think it was the first thing I wrote that drove home the power of having a REPL for exploratory programming:
http://blip.tv/rupy-strongly-dynamic-conference/david-beazly...
yes - output a string repeatedly until killed
That's for personal stuff, not sure if there are corporate options.
Some of the benefits I find are:
1. Getting into the pessimistic mindset helps produce better estimates
2. Tasks with a large spread are things you aren't really clear about, and are an obvious target to be attempted first
3. Giving a range of values to the person asking for the estimate seems to help them remember it is an estimate.