$tbl_ary_ref = $sth->fetchall_arrayref;
$tbl_ary_ref = $sth->fetchall_arrayref($slice);
$tbl_ary_ref = $sth->fetchall_arrayref($slice, $max_rows);
$tbl_ary_ref = $sth->fetchall_arrayref({foo=>1, BAR=>1});
$tbl_ary_ref = $sth->fetchall_arrayref({});

# They all are named the same but do things 
# differently. Which is strange, because Perl 
# makes a big deal (rightfully so, in my view)
# that different things should look different.
#
# The last two are particularly perplexing (to me).
# they don't even have the word 'hash' yet fetch
# every row as a hash ref!
#
# That said, I use the last one all the time 
# because I can pass the returned data structure
# directly to my beloved [cpan://HTML::Template] object.
[download]

Otoh, it could be just me. After a few years at Perl, I still can't tell the various punctuation variables apart (other than $_ and @_). It is funny, last week a friend went for an interview for a Perl job -- they had a quiz for him, and asked if what $& stood for. I would have failed the quiz immediately! Yet, I can program to save my life.