a1ex07

less info
meta site favicon meta user | stack exchange network profile network profile
2,645 reputation
29
bio website
location Vancouver, Canada
age
visits member for 1 year, 11 months
seen 13 hours ago
stats profile views 66

104 Answers

newest activity votes
7
How can I improve this DB query? it takes too much time
nov 21 at 16:52
6
File name as primary key?
dec 22 '11 at 19:24
5
SQL Server OPENQUERY vs Regular Query against AS400
jan 17 at 16:17
5
Swap Columns on some rows?
dec 26 at 17:52
5
What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint?
apr 9 '12 at 16:20
4
Splitting SQL query with many joins into smaller ones helps?
jun 1 at 17:57
4
Database structure for tags?
may 18 at 13:58
4
SQL Server pivot query on Oracle source
dec 10 at 21:14
4
SQL Server Express vs. Oracle Express Edition vs DB2 Express-C
sep 1 at 14:45
4
unique constraint on a set
aug 8 at 17:24
4
Similar queries taking different times to complete
jul 19 '12 at 15:26
4
How can I select using the same fields from an undetermined number of tables using MySQL?
apr 13 '12 at 15:21
4
Oracle: UTL_RAW.BIT_OR(2,1) gives me 2 instead of 3. Why?
mar 7 '12 at 21:40
4
Tables with hierarchy: create a constraint to prevent circularity through foreign keys
mar 5 '12 at 17:12
3
A database in MySQL is a schema in Oracle : I do not understand this statement
mar 4 at 16:23
3
Only one NULL for one part of primary key
mar 3 at 5:57
3
Combining two similar SQL queries
dec 16 at 13:08
3
How to GROUP_CONCAT between given rows?
dec 14 at 22:26
3
Foreign key of multiple tables
dec 10 at 21:10
3
Should we add extra 5 columns or build a separate table?
jun 14 '12 at 17:07
3
Can I have one table be an “alias”, or “symlink”, to another?
may 25 '12 at 23:40
3
Mysql int vs varchar as primary key (InnoDB Storage Engine?
apr 1 '12 at 14:49
3
How do I preserve the leading zeros when I insert a number into this table?
mar 15 '12 at 15:48
3
How do I prevent updates on an entire table (but allow inserts) in Mysql 5.5?
mar 10 '12 at 13:51
3
Window functions cause awful execution plan when called from a view with external parametrized 'where' clause
feb 8 '12 at 19:23
3
How to keep long multiple of questions and answers in database?
dec 18 '11 at 17:57
2
Is it possible to validate DML statements?
may 7 at 14:36
2
Foreign Key to Multicolumn Primary Key?
may 1 at 18:50
2
ORDER BY clause is allowed over column that is not in SELECT list?
feb 18 at 17:56
2
What is the correct result for this query?
jan 29 at 17:45
1 2 3 4