All Questions
Tagged with sql-server design
19 questions
35
votes
6
answers
10k
views
SQL as a means of avoiding "releases"
The system I'm working on started as a small training project within the company I work for but quickly caught interest from management as a means to help to standardize the existing excel-heavy ...
- 467
0
votes
1
answer
96
views
Finding/determining future data for pricing
I'm honestly not even sure how to go about how to ask what I'm looking for/need. lol.
I'm currently using Sql Server for my database and the 'new' .net 5. There are multiple pricing tables that each ...
- 19
1
vote
1
answer
396
views
Designing low fault software rest API calls to achieve data synchronization between two different systems
I have been looking for a better design approach and will be providing my problem statement here with a similar example. As I don't have logic already in place but have the solution in mind which I ...
- 181
3
votes
4
answers
513
views
How to Handle Item Prices Change for Reporting
I am building a Point of sales software with Sql Server 2008-R2. I am now confused about how to handle multiple items with prices change.
Let us say price of Pepsi is $2.0 on 10-09-2019 but today it'...
- 33
0
votes
1
answer
199
views
Venue Reservation System Logic Approach/Clarification
I hope this is the right place to ask since this is a programming related question.
I’m developing a venue reservation app (similar to booking.com) and am almost done however I have 1 request for ...
- 103
3
votes
1
answer
127
views
Regulations about collecting data from software running at clients hardware (apps 'phoning home') [closed]
We develop an application which has now been installed on a few thousand customers sites.
Unfortunately, we have no customer data collection built into the software. This is something we want to ...
- 49
0
votes
1
answer
559
views
Database design: where to store a "current" or "selected" flag in a parent-child hierarchy [duplicate]
Sorry, maybe it's a well known design principle, but because I don't know a name for this kind of relation, I was not able to find any existing answer.
So, let's say we have a parent which may have ...
- 109
4
votes
2
answers
618
views
Is using spacing effectively equivalent to the long method code smell?
There's a common code smell involving long methods with the most common answer being that methods should be really small, less than 50 lines per say (or 20). I understand why this is because it ...
- 151
1
vote
2
answers
286
views
Querying Active Directory from SQL Server
We always used C# to query Active Directory, recently we need to add a patch to some code and it would be easier for us to query Active Directory straight from SQL DB as then we won't need to make ...
- 1,007
2
votes
3
answers
69
views
Verbose specification of exact Table or Implied
Consider the following two queries in SQL (Transact SQL):
UPDATE [database_name].[dbo].[table_name]
SET [database_name].[dbo].[table_name].[field_name] = @value
WHERE [database_name].[dbo].[...
- 131
6
votes
1
answer
429
views
How to set up a sql database to cater for user records, group records and default records?
Outline
I have an application that loads data from a database. I'm not talking about client data here though, I'm talking about application configuration. The database will therefore come with some ...
- 169
22
votes
6
answers
20k
views
When should I use stored procedures?
If I have all my business logic in code and make use of Entity Framework, in what situations (if any) would I be better moving some business logic to a stored procedure, instead of keeping it all in ...
- 493
5
votes
2
answers
3k
views
One wide table or multiple themed tables?
I'm trying to design a database for a simple text based game where the player characters have a large number of statistics that I want to track. Currently I have a few groups of related statistics, ...
- 173
1
vote
1
answer
2k
views
Multi-tenant database design
My boss is currently working on a database design for a multi-tenant capable ERP/CRM system, which will have a Sql Server backend.
Some key points of the design:
A server instance will host a "shared"...
- 1,657
4
votes
2
answers
783
views
Data persistence for transactional customer emails
I'm developing a system to handle sending transactional emails to our customers. This is how it works:
An event occurs during the order's life cycle, for example 'shipped'
This event will trigger ...
- 91