To barrow from SSCrazy's data, I had this idea for grouping the data:

DECLARE @PersonAction TABLE (

PersonID VARCHAR(1) NOT NULL

,actiondate DATETIME NOT NULL

...

I was experimenting with the RAND() function one day and thought it would be cool to wrap it up with a ROW_NUMBER / PARTITION BY / OVER clause to see...

I do use temporary indexes when I'm crunching large datasets. This is usually the case for our month-end reports. In one report it cut our execution time from over 8...