1,149 reputation
714
bio website
location
age
visits member for 2 years, 9 months
seen Apr 17 at 11:54

Oct
24
answered Connection To R2 Named Instance
Oct
10
awarded  Enthusiast
Oct
6
revised Improving the performance of a long query
added 55 characters in body
Oct
6
answered Improving the performance of a long query
Oct
5
comment SQL Server 2005 database engine login failed error?
Just accept the answer, if it helped you.
Oct
5
revised SQL Server 2005 database engine login failed error?
added 181 characters in body
Oct
5
answered SQL Server 2005 database engine login failed error?
Sep
22
answered Where does my.cnf get stored in Linux?
Sep
20
awarded  Editor
Sep
20
revised Database design for dynamic Meta fields of an entity that shall be queried intensively
added short clarification
Sep
20
answered Database design for dynamic Meta fields of an entity that shall be queried intensively
Sep
18
awarded  Scholar
Sep
18
accepted Which areas of a DBA's knowledge should a developer delve into?
Sep
16
answered Which is quicker: Select of existing row vs Update where no row exists?
Sep
16
awarded  Student
Sep
16
asked Which areas of a DBA's knowledge should a developer delve into?
Sep
15
comment Should fields that aren't needed often be kept in separate tables?
+1 for: "To sum it up, I think you've got a bigger performance problem in using an ORM than in storing the descriptions in the same tag table."
Sep
12
comment MySQL Auto_increment going 2 by 2
As the documentation says, it's not possible to set it db or table-wise. I'm sorry, I can't help you here. Maybe you are trying to achieve something with the autoincrement feature that it wasn't intended for.
Sep
12
answered MySQL Auto_increment going 2 by 2
Sep
12
comment Weird error on simple query in MsAccess
ORDER BY should work with 2010, but it's not really sorting on the whole field content. But the problem in your case is the combination with DISTINCT, as Access is truncating internally the memo field to sort on it (like in my above sample). And that conflicts with DISTINCT.