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.)
skip to main |
skip to sidebar
Wednesday, October 31, 2007
Subscribe to:
Post Comments (Atom)
Kate...
Archive
Labels
- #picmecomp (1)
- books (21)
- career (18)
- computer geekdom (40)
- conferences (39)
- datamining (8)
- frisbee (3)
- games (5)
- ghc08 (5)
- ghc10 (3)
- ghc11 (15)
- ghc12 (13)
- ghc13 (9)
- graduate school (23)
- iPhone (5)
- languages (1)
- LaTeX (3)
- life on a mountain (19)
- linux (3)
- movies (1)
- music (5)
- photography (6)
- programming (19)
- radio (4)
- robotics (21)
- scholarships (10)
- science fiction (33)
- science news (19)
- travel (54)
- windows phone (4)
- Women in Computing Science (65)
No comments:
Post a Comment