miracle173

1,308 reputation

bio	website
	location	Austria
	age
visits	member for	1 year, 11 months
	seen	yesterday
stats	profile views	74

Oracle : 7.3.4, 9.2, 10.1, 10gXE, 10.2, 11.2
Mysql : 5.5, internals
Sqlserver : 2012, 2008 R2, 2008, 2005, 2000
DB2 9.7
PostgresSQL
Microsoft Windows System Error Codes
Linux errno.h
Java Java 7
Other: Sqlfiddle pastebin
Articles
Editing Help; allowed HTML; Reference
T.J.Teorey, D.Yang,J.P.Fry: A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model

	1,308 reputation	bio	website		visits	member for	1 year, 11 months
28 badges		location	Austria		seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

29 Favorites

added views newest activity votes

votes

answers

kviews

Where are some useful SQL puzzles to teach SQL in a workplace?

sql

oct 2 '11 at 17:58 Lazer 975

votes

answers

kviews

What are the arguments against or for putting application logic in the database layer?

database-design

oct 17 at 12:21 Ruud van de Beeten 193

votes

answers

249

views

What are the canonical NoSQL resources for people who never used this technology?

nosql

apr 19 '12 at 14:21 Alex Popescu 146

votes

answers

316

views

Can this business logic be enforced by a conditional database constraint?

oracle database-design oracle-11g-r2 constraint

sep 17 at 21:51 kevinsky 1,548

votes

answers

kviews

Tools to monitor Oracle Database Performance on Standard Edition

oracle performance oracle-se

dec 2 '11 at 23:09 RolandoMySQLDBA 41.6k

votes

answer

220

views

Package state not re-intialized on raise_application_error

oracle oracle-11g-r2 plsql error-handling

mar 1 at 14:02 Leigh Riffel 13.8k

votes

answer

239

views

Is it ALWAYS possible to avoid cursor?

sql-server

jan 29 at 20:21 Aaron Bertrand 35.9k

votes

answers

149

views

Cardinality rule for bitmap indexes

oracle data-warehouse index-tuning bitmap-index star-schema

dec 14 at 16:11 Chris Saxon 1,387

votes

answer

278

views

Oracle aggregate functions slows query down massively

oracle performance aggregate

dec 10 at 17:05 user1578653 202

votes

answers

kviews

Determine Index Compression Candidates Online

oracle oracle-11g-r2 index oracle-11g

jul 8 '11 at 18:17 Leigh Riffel 13.8k

votes

answers

132

views

Obtaining gratis copy of the SQL specification?

books standards

aug 28 at 14:47 Erwin Smout 603

votes

answer

395

views

Oracle integer to number conversion

oracle datatypes

sep 5 at 22:50 Jack Douglas♦ 12.8k

votes

answers

233

views

Increase Oracle buffer cache gets slower

oracle performance oracle-11g-r2

dec 5 at 5:28 Sanjaya Balasuriya 1

votes

answers

102

views

How can I mimic functionality of SQL Server `TYPE` in Oracle?

oracle feature-comparison usertypes

dec 6 at 13:19 Leigh Riffel 13.8k

votes

answers

views

Algorithmic order of table indexes for table operations

sql sorting index

jan 21 at 10:03 Shlomi Noach 2,050

votes

answer

132

views

How to search for an ID and its descendants in this query?

oracle query optimization query-performance

feb 20 at 23:23 Community♦ 1

votes

answers

131

views

What's the best practice for representing set operations in a relational database?

database-design

feb 27 at 11:56 Chris Travers 5,416

votes

answer

282

views

column precision exceeded. ORA-01438 is so unmeaningful

oracle prepared-statement

apr 9 at 2:01 Community♦ 1

vote

answers

134

views

Separate or Combine 2 Tables with Similar Attributes?

database-design normalization

dec 30 at 17:15 a1ex07 2,508

vote

answer

575

views

database functional dependency candidate keys

relational

jan 29 '12 at 15:05 Community♦ 1

vote

answers

596

views

How much do foreign keys affect performance?

sql-server-2008-r2 performance foreign-key

jan 2 at 9:07 Grijesh Chauhan 234

vote

answer

310

views

ER Diagram translation to tables

database-design

feb 23 at 11:42 ypercube 8,749

vote

answers

408

views

Designing a Products database: One Products table or many separated by vendor?

database-design

jan 23 at 12:04 Chris Saxon 1,387

vote

answer

483

views

Planning simple CMS: How much relation?

database-design optimization database-tuning database-theory cms

jan 23 at 10:15 Chris Travers 5,416

votes

answers

views

mysql: how many disk seeks were made for a select query

mysql sql tuning

apr 2 at 6:32 Karthik Appigatla 1

votes

answer

173

views

oracle clob export/import across non linked instances

oracle migration

jan 28 at 15:13 Vincent Malgrat 2,844

votes

answers

155

views

How to resolve TNS error in Oracle when using an ODBC DSN

oracle

jan 9 at 9:04 Mat 3,315

votes

answers

465

views

Run Unix command using PL/SQL

oracle-11g-r2

may 5 at 15:05 Community♦ 1

votes

answers

133

views

What is the best database design to keep track of fields with multiple values?

database-design

jan 3 at 12:31 Community♦ 1