Random findings
November 11th, 2008 . by Loris- SQL Server: you can use the command:
DBCC SHOWCONTIG (@TABLENAME)to display paging statistics about a table (MSDN article) - C#: Use
ConfigurationManager.GetSection()to read any section of yourweb.configorapp.config(from my StackOverflow question) - You can use only one SQL query per
OleDbCommand! The OleDb provider does not support chaining SQL Queries with ";" - ASP.Net’s ListBox control does not support the
<optgroup>tag! - In SQL Server CE, you cannot
SELECT TOP n. The syntax isSELECT TOP(n), but can only be used starting from version 3.5 (StackOverflow) . - 64bit madness: If you’re referencing a COM assembly in your .Net application, you should compile it for 32 bit machines, or it will fail silently (but putting a vague error message in the event log) when run on a 64bit edition of Windows.
The same applies if you’re referencing aComVisible.Net assembly in your VB6 application (don’t ask
).
If you’re on ASP.net, it gets even nastier. - You can change a .net application to always run in 32 bit without recompiling it, using the
CorFlagsutility from the .net SDK (via Simon Green’s blog).