User Michael Green

6 votes

Accepted

How is one or more aggregate function implemented in most SQL engines?

answered Apr 21, 2016 at 2:44

4 votes

In what conditions (if any) is it good practice to query two servers and only consume the fastest response?

answered May 18, 2018 at 0:00

4 votes

Accepted

Let applications share a database or keep them in sync with web services?

answered Jul 4, 2014 at 12:34

4 votes

What really is the difference between relational and non-relational data?

answered Apr 4, 2020 at 12:20

3 votes

Accepted

Repurpose MySQL as a mutex

answered Aug 29, 2014 at 4:01

3 votes

Is this database design sound and fully normalised?

answered Jun 25, 2014 at 12:06

3 votes

DB Enumerations vs App Enumerations vs Lookup tables

answered Sep 18, 2018 at 23:33

3 votes

Accepted

What are possible ways to avoid duplicates when you can't add an unique index

answered Dec 14, 2017 at 3:43

2 votes

More scalable alternative to a transaction-per.request in a SQL+REST stack?

answered Jul 5, 2016 at 11:54

2 votes

DB structure for similarity detection

answered Mar 15, 2017 at 22:15

2 votes

Data persistence for transactional customer emails

answered Sep 4, 2014 at 4:00

2 votes

Creating menu structure using DB - is that fine?

answered Jul 27, 2014 at 10:42

2 votes

Accepted

How to Design for Monthly Database Refreshes?

answered Sep 13, 2019 at 2:05

2 votes

Accepted

Equivalent attributes and normal forms

answered Jun 25, 2020 at 12:57

2 votes

Displaying various subsets of content stored in a database

answered Feb 11 at 14:23

1 vote

Extensible hierarchical database design

answered Sep 9, 2020 at 12:37

1 vote

How do you name "*_statuses" for multipe tables so that there'll be some pattern in the names of the statuses?

answered Jul 2, 2020 at 11:09

1 vote

Accepted

Is a transaction time of <10ms for an SQL database viable? If so, under what conditions?

answered Jul 2, 2020 at 12:12

1 vote

Propagating MDS Data - SQL Service Broker or SignalR?

answered Sep 19, 2019 at 5:20

1 vote

Using sql triggers over higher level scripts

answered Jan 8, 2019 at 3:31

1 vote

what extra benefit do I get from a caching layer over the caching layer of the database?

answered Apr 9, 2020 at 11:40

1 vote

How should I handle Stored Procedure parameters that need to be the same length as a column?

answered Sep 11, 2019 at 11:59

1 vote

Optimizing inserting/storing Large amount of data in database

answered Dec 5, 2019 at 10:43

1 vote

Structural pattern for an unconventional use of a database

answered Aug 11, 2014 at 0:01

1 vote

Ranking players depending on decision making during a game

answered Aug 24, 2014 at 23:25

1 vote

Can Excel be a strong development platform?

answered Jul 11, 2014 at 0:07

1 vote

Are mutliple database calls really significant with a network call for a web API?

answered Sep 4, 2014 at 3:46

1 vote

Trying to "combine" similar objects without doing a bazillion comparisons

answered Apr 9, 2014 at 12:36

1 vote

Is the system with no central storage more secure?

answered Nov 27, 2017 at 23:38

1 vote

SQL Query and Java Constant Abuse?

answered Aug 21, 2016 at 23:39

Stack Exchange Network

53 Answers

How is one or more aggregate function implemented in most SQL engines?

In what conditions (if any) is it good practice to query two servers and only consume the fastest response?

Let applications share a database or keep them in sync with web services?

What really is the difference between relational and non-relational data?

Repurpose MySQL as a mutex

Is this database design sound and fully normalised?

DB Enumerations vs App Enumerations vs Lookup tables

What are possible ways to avoid duplicates when you can't add an unique index

More scalable alternative to a transaction-per.request in a SQL+REST stack?

DB structure for similarity detection

Data persistence for transactional customer emails

Creating menu structure using DB - is that fine?

How to Design for Monthly Database Refreshes?

Equivalent attributes and normal forms

Displaying various subsets of content stored in a database

Extensible hierarchical database design

How do you name "*_statuses" for multipe tables so that there'll be some pattern in the names of the statuses?

Is a transaction time of <10ms for an SQL database viable? If so, under what conditions?

Propagating MDS Data - SQL Service Broker or SignalR?

Using sql triggers over higher level scripts

what extra benefit do I get from a caching layer over the caching layer of the database?

How should I handle Stored Procedure parameters that need to be the same length as a column?

Optimizing inserting/storing Large amount of data in database

Structural pattern for an unconventional use of a database

Ranking players depending on decision making during a game

Can Excel be a strong development platform?

Are mutliple database calls really significant with a network call for a web API?

Trying to "combine" similar objects without doing a bazillion comparisons

Is the system with no central storage more secure?

SQL Query and Java Constant Abuse?