June 28, 2012 at 11:56 am
I am looking at a database designed by someone else.
I see he named the columns like Date_SK, Date_PK, Race_SK, ReaceCOde_NK.
What does these SK and NK could mean?
Thanks
June 28, 2012 at 12:12 pm
Guessing at what he intended:
SK = SurrogateKey
NK = NonKey
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 5:23 pm
I think the only one that can really answer that question is the original developer.
Mark
June 28, 2012 at 5:35 pm
Yes, I ask one developer who has similar table columns, he said SK is surrogated key, NK is natural key
June 28, 2012 at 9:42 pm
sqlfriends (6/28/2012)
Yes, I ask one developer who has similar table columns, he said SK is surrogated key, NK is natural key
OK - I would not recommend such a naming convention.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 29, 2012 at 10:01 am
Thanks all.
June 29, 2012 at 1:49 pm
you're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply