Questions tagged [physical-design]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
19
votes
1answer
5k views

Composite Primary Key in multi-tenant SQL Server database

I'm building a multi-tenant app (single database, single schema) using ASP Web API, Entity Framework, and SQL Server/Azure database. This app will be used by 1000-5000 customers. All the tables will ...
0
votes
1answer
26 views

B2B application: users has its own users

B2B Scenario I am trying is that: The following Roles exists in the system: Super Admin Super Admin Staff Owner (client) Admin (owner i.e. client and creates admin to define sales counters) Sales ...
5
votes
2answers
18k views

Separate stored procedures for inserts and updates?

I have a table in Microsoft SQL Server. Sometimes I need to update, and sometimes I need to insert. I could write 2 stored procedures: InsertNewPerson UpdatePertsonById But I was thinking to write ...