Reputation
4,405
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 14 34
Newest
 Suffrage
Impact
~167k people reached

7h
reviewed Close While querying view using linked sever getting error as “Requested conversion is not supported”
9h
comment SQL Server Concurrency Issue
Maybe different processes shouldn't be working with the same isModified = 1 subset. Maybe you could create a SQL Server Agent job that would do all this at regular intervals. Or maybe you could take a different approach altogether instead of using isModified. Knowing what the "whole bunch of JOINS" are might help. Or it might be completely irrelevant, but you could start with a short explanation of what these five statements are doing, in essence.
9h
reviewed Reviewed Memory Table and Disk Table
9h
revised Memory Table and Disk Table
added 8 characters in body; edited tags; edited title
9h
reviewed Reviewed Partitioning a table on a column in another table
9h
revised Partitioning a table on a column in another table
added 26 characters in body; edited tags; edited title
9h
reviewed Reviewed Cluster of Clusters (Not using MySQL-Cluster)
9h
revised Cluster of Clusters (Not using MySQL-Cluster)
formatting, spelling, punctuation
10h
reviewed Reviewed Can't get databases or its objects with powershell
10h
reviewed Approve Moving the binary location of MySQL for replication
18h
revised Unable to create UNIQUE Filtered index with IGNORE_DUP_KEY = ON
linked to live demo
18h
answered Unable to create UNIQUE Filtered index with IGNORE_DUP_KEY = ON
Feb
5
comment How to relate a [ parent common] table with (possibly many) subtype tables?
@StixO: If you are struggling with making your verbal description perfectly clear and unambiguous, perhaps you could update your question with examples (data samples) illustrating what is and what isn't possible in the set-up you are trying to implement.
Feb
5
comment How to relate a [ parent common] table with (possibly many) subtype tables?
My understanding now is that any one row in SystemCommon is to be related to just one row in just one of the four SystemType tables. Is that correct? If so, this looks like a case of table inheritance to me. I'm sure I've seen questions on this topic (some of them with great answers by @MDCCL too), but I'm still struggling to find one that would best fit your scenario (and also contain an example of implementation), without irrelevant details so as to make it less confusing for you.
Feb
5
comment How to relate a [ parent common] table with (possibly many) subtype tables?
Perhaps I'm missing something but why are you talking about parents and types? Is the Parent table supposed to be a parent to a (sub)type table or is it a parent to a completely different table? If it's important for us to know that the table with which you are trying to associate a SystemType table is a parent table (to something else), please show the relevant parent-child relationship. But if a child table is irrelevant to the problem, then please don't use the term "parent", that's just confusing. I mean, if I knew why that was important, I might understand your issue better.
Feb
5
comment What is the correct way to rename/swap a table in production
Or maybe you could elaborate in your question how you did the renaming (exactly what commands or tools you used). All the more so since you've already been pointed to a couple of renaming methods.
Feb
4
reviewed Close Which data type should I use to store a 11 digit number
Feb
4
comment Fatal error when not numeric value - PostgreSQL 9.2
You could have spared people's time by not posting your question until you got the complete information.
Feb
4
reviewed Close Is there a TSQL command or another way to rename AOAG (Always On Availability Group)?
Feb
3
revised Slow subquery in SELECT statement
formatting