1,179 reputation
1815
bio website
location
age
visits member for 3 years, 3 months
seen Oct 16 at 12:57

Jul
13
comment MySQL table design / architecture, table is too big
Values in TEXT columns are not stored in the row buffer, but nonetheless get stored in the database at some other memory location (depending on storage engine). Including TEXT fields in your queries might give you performance problems (see: stackoverflow.com/questions/2883867/…)
Jul
12
awarded  Yearling
Jul
12
answered MySQL table design / architecture, table is too big
Jul
6
revised MySQL table with 100,000 records queried often
formatting
Jul
6
suggested suggested edit on MySQL table with 100,000 records queried often
Jul
5
accepted Directly acessing the NULL bitmap of a row in SQL Server
Jul
5
asked Directly acessing the NULL bitmap of a row in SQL Server
Jul
3
comment What is the actual lowest possible positive REAL number
+1: Haven't heard about subnormal numbers yet.
Jun
29
revised How to detach a sql server 2008 database that is not in database list?
edited tags
Jun
26
comment How to compare two SQL Server 2008 configurations
I know, that's why just a comment as additional info to your answer. Usually you got 80% default settings. So this way you're left to compare only the remaining 20%. (+1 btw)
Jun
26
awarded  Commentator
Jun
26
comment How to compare two SQL Server 2008 configurations
Check out the script at sqlserverperformance.idera.com/uncategorized/… to quickly spot non-default settings for SQL Server 2008.
Jun
20
revised Where is this mystery trace going (SQL Server 2000)?
added quote
Jun
20
answered Where is this mystery trace going (SQL Server 2000)?
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
9
comment Is Index causing timeouts?
As soon as the first column in your index is not used in your query, the index cannot be efficiently used. Also, maybe you deleted some indexes that were crucial for some queries that now time out. I once had better performance using single indexes for each query column instead of a large combined one (stackoverflow.com/q/702469/44522).
Feb
17
comment Why can't I connect to SQL Server 2008?
Your SQL Server Browser service is maybe not running. See my checklist in this answer: stackoverflow.com/a/6001023/44522
Jan
6
awarded  Enlightened
Jan
6
awarded  Nice Answer