Emmad Kareem

less info

network profile

645 reputation

27

bio	website
	location
	age
visits	member for	1 year, 2 months
	seen	Apr 23 at 15:01
stats	profile views	30

summary answers questions tags badges favorites bounties reputation activity

22 Favorites

added views newest activity votes

14

29

votes

5

answers

1

kviews

Is there a name for this database structure?

database-design schema eav ontology

jan 6 at 23:25 Melvin PRESSOUYRE 71

1

23

votes

5

answers

2

kviews

Why do sequential GUID keys perform faster than sequential INT keys in my test case?

sql-server clustered-index

aug 4 at 9:18 Community♦ 1

3

13

votes

3

answers

2

kviews

Running total with count?

sql sql-server

feb 7 at 7:19 ypercube 8,749

1

7

votes

3

answers

657

views

Oracle: How do I query a Hierarchical table?

sql oracle query view hierarchical

jul 3 at 17:51 Leigh Riffel 13.8k

1

5

votes

2

answers

124

views

Unique Contraint/Index Based On Values

sql-server sql-server-2005 index constraint

jul 30 at 21:39 njvds 51

1

5

votes

3

answers

2

kviews

Inventory database structure when inventory items have varying attributes

database-design database-structure eav

nov 13 at 10:48 Erwin Brandstetter 8,772

1

4

votes

3

answers

530

views

How can I write a proper query to JOIN all of these tables without duplicates?

mysql sql-server-2008 sql sql-server-2005 postgresql

apr 13 '12 at 21:32 Erwin Brandstetter 8,772

2

3

votes

3

answers

4

kviews

T SQL Table Valued Function to Split a Column on commas

sql-server-2008

feb 15 at 22:52 Kenny Evitt 99

3

3

votes

3

answers

193

views

optimizing a compare query

oracle query optimization query-performance

aug 22 at 13:48 Jack Douglas♦ 12.8k

1

3

votes

2

answers

281

views

Should I use select count(*) for counting records or having a field like comments_no for tables like post, comments?

innodb select count update mysqli

mar 1 at 7:29 Community♦ 1

1

3

votes

2

answers

782

views

COUNT and SUM at the same time after removing duplicate rows

postgresql

sep 6 at 15:01 Emmad Kareem 645

2

3

votes

3

answers

179

views

Database design for changing number of fields

mysql database-design php

sep 14 at 5:08 Max Vernon 4,196

1

3

votes

1

answer

817

views

Product Attribute List Design Pattern

mysql database-design

sep 26 at 12:25 bluefeet 1,896

1

2

votes

3

answers

571

views

Unique combination key MySQL

mysql unique-key

aug 7 at 15:14 RolandoMySQLDBA 41.4k

1

2

votes

1

answer

236

views

query generate the information one column in two columns in one query

mysql sql mysql-5

aug 16 at 21:19 RolandoMySQLDBA 41.4k

1

2

votes

2

answers

104

views

Long JOINS Returns No result all tables have one to many relationship with a particular table

mysql database-design join derby

aug 27 at 14:34 HLGEM 2,271

1

2

votes

2

answers

195

views

creating a database scheme for storing information about an item, which option is better?

database-design schema

jul 3 at 15:22 ypercube 8,749

2

1

vote

1

answer

283

views

Unable to add records to query in Access 2007

query join ms-access

sep 10 at 14:11 Max Vernon 4,196

2

1

vote

2

answers

252

views

Database design experienced view

database-design best-practices database-recommendation homework

aug 29 at 21:00 Max Vernon 4,196

1

1

vote

2

answers

73

views

Efficiency for contact-contact relationships schema

optimization join

sep 26 at 1:51 Michael - sqlbot 3,138

1

0

votes

1

answer

336

views

Db design for a quiz with variable number of answer choices, and each worth different score in a different category?

mysql schema database-structure

sep 10 at 12:46 Max Vernon 4,196

1

0

votes

1

answer

118

views

Updating a table based on condition

sql-server-2008 sql update

jul 4 at 10:50 Emmad Kareem 645

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Arqade (gaming) Bicycles Role-playing Games more (22)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.5.22.696

Database Administrators Stack Exchange works best with JavaScript enabled