I hadn’t used this handy tool in sql server in a while and actually had to look it up recently, so here it is in the code review.

TRUNCATE TABLE “table_name”

Truncating not only deletes all of rows in the table, but it deletes all information about the table, which makes all auto numbering integer fields start over at 1.  Not complicated, but surprisingly few people know about it.

Read more on How to Truncate a Table in Sql Server…

Popularity: 1% [?]

The first entry in my Code Review is the List<>.

So far, the List is my favorite sort of array in C#.  It has the benefits of

• being obvious in naming

Read more on The List<> in C#…

Popularity: 1% [?]

One of the lessons I learned from John Medina’s excellent book Brian Rules is that of elaborative rehearsal, which is (roughly) defined as remembering something more strongly by doing something with the new information, like giving a book report or relating that information back into something you already know.   Example: Say you already know the geography of Central Asia, if you wanted to remember the story of Genghis Khan, you could relate Genghis’ story to the already known geography, and then giving an oral report on old Genghis.

Read more on Introducing the new Code Review Category…

Popularity: 1% [?]