Reputation
38,990
Next tag badge:
106/100 score
18/20 answers
Badges
3 58 122
Impact
~1.8m people reached

Apr
25
awarded  Great Answer
Apr
22
awarded  Enlightened
Apr
22
awarded  Nice Answer
Apr
15
awarded  Nice Answer
Mar
25
answered Why is my SQL .mdf file 30GB when my data is only 4GB
Mar
25
awarded  Enlightened
Mar
25
awarded  Nice Answer
Mar
22
comment Should we create a schema per “project”?
All in all there is no silver bullet. Multi-tenancy has many issues and none of the solutions is perfect. You and your team are best positioned to choose the right balance for you.
Mar
22
comment Should we create a schema per “project”?
Also something for you to evaluate: impact of skew. Is often the case that that few tenants (projects) contain most data. It is often best to isolate these big impact tenants onto their dedicated DB(s) as a first step.
Mar
22
comment Should we create a schema per “project”?
As a first step I would start by making every clustered index key start with the project id. It will give you most of the advantages you were after (as every query specifies a project_id, which I'm sure your app does, I hope), and the overhead/cost is smaller.
Mar
22
comment Should we create a schema per “project”?
I would advise against partitioning the tables per project ID. You can, at the very best, make 15k partitions on a table, so you will end up mixing projects in a partition anyway. Partitioning has a cost, see How To Decide if You Should Use Table Partitioning.
Mar
21
comment Should we create a schema per “project”?
What do you mean by "database partition on ProjectID" ?
Mar
21
revised Should we create a schema per “project”?
added 610 characters in body
Mar
21
revised Should we create a schema per “project”?
added 610 characters in body
Mar
21
answered Should we create a schema per “project”?
Mar
18
awarded  Autobiographer
Mar
16
comment mariadb can't import sql which contains \' in insert statement
Can you post the actual line 4393 of the script?
Mar
15
comment DBCC CHECKDB ran out of memory
Since you're getting memory status dumps, can you post them here? The answer is in them.
Mar
15
comment In SQL Server, how do read locks work?
* on its own is a bad practice because when table structure changes the application usually breaks (unexpected columns appear in result).
Mar
8
answered MS SQL Server, ask password before drop specific DB