Wednesday, October 31, 2007

So Others Will Not Share My Pain

Two things I learned today:

1) LaTeX
To include a .cls stylesheet in a LaTeX document, simply place it in the same directory. Easy!

2) .NET
When making queries to very, very large tables (>>5 million tuples), if you are doing statements with aggregation, like select count(*), make sure to add the following line (in bold) after you create your command. For example:

SqlCommand getSizeCmd = new SqlCommand(tempCommand, myConnection);
getSizeCmd.CommandTimeout = 10000;

Otherwise, pain, pain pain, I tell you!

(Basically, you will get timeout errors every time.)

No comments: