There might be references to CV in higher education or lazy multi-nationals but if I asked standard folks about their CV, they might think I was referencing the drug store, CVS
I have 4 dimensions with patient data. In each dimension there's an ID for the patients. The only problem is that I have no idea how to merge the 4 dimensions into 1 new dimension.
I would use a merge join, but that doesn't work since I also have patient records with no ID. I can't match the pat...
anyone have any good articles on using a surrogate key like identity over a large varchar as a primary key? Someone has suggested using a varchar(255) which would then be stored in 2 other tables as a FK. I suggested using an identity instead - why store 255 when we could store something much smaller
@Kermit Well, so I'm code reviewing something and they have a table like create table ( name varchar(255)) with the PK being on that column. This is then referenced as a FK for 2 other tables. My suggestion was create table (id int identity PK, name varchar(255)), then reference id in the other tables. They want to know why that's better. I'm looking for any "documentation" or something that I could use to say storing the id instead of the varchar(255) would make more sense.
I think the main issue is indexing. Any index that includes the varchar would be about 10 times wider.
So, 10 times less keys in a page.
(assuming an average of 40-50 chars per value)
And secondary, whether the name is ever going to be updated or not. If yes, you'll have to either have the FKs with cascading updates or do the cascades in code. Either way, updating millions of rows is not good.
I have a string variable that i am trying to pass into omy OLE DB Source query. It looks something like this:
'stuff', 'more', 'stuff2'
I am inserting the variable doing this:
AND T.TEAM_NAME IN (?)
If I actually replace the variable in the query and do:
AND T.TEAM_NAME IN ('stuff', 'more'...
i have an really old database with a really bad table structure and I'm trying to create these tables with a better structure. For doing this, I need to match two tables, to get the id of a category.
Here are my two old tables:
table categorys:
| ID | catname | cat1 | cat2 | ca...
A month ago I sent an email to our helpdesk stating (there's a broken/missing image) on this client's public website. It's referencing the sharepoint internal name. They keep emailing me asking me if it's resolved. They aren't doing anything to fix it, just keep asking me if it's fixed
It's not assigned to me to be fixed, but they don't fix it so I wonder if they just think I'll eventually capitulate and say it's fixed so they can close the ticket
I have a string variable that i am trying to pass into omy OLE DB Source query. It looks something like this:
'stuff', 'more', 'stuff2'
I am inserting the variable doing this:
AND T.TEAM_NAME IN (?)
If I actually replace the variable in the query and do:
AND T.TEAM_NAME IN ('stuff', 'more'...
i have an really old database with a really bad table structure and I'm trying to create these tables with a better structure. For doing this, I need to match two tables, to get the id of a category.
Here are my two old tables:
table categorys:
| ID | catname | cat1 | cat2 | ca...
