Foreign Keys

Question

Foreign Keys

Steve Jones - SSC Editor

SSC Guru

Points: 736160
More actions
August 26, 2018 at 9:58 am

#77281

Comments posted to this topic are about the item Foreign Keys

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72623 More actions · Answer 1

Nice question to start the week on, thanks Steve...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

So in other words WAY more than you should ever get close to. I can't even imagine a system where that limit is even close to being reached. YIKES!!!!

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

ZZartin SSC-Dedicated Points: 30920 More actions · Answer 3

Now I wonder how many people have actually reached that limit.

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 4

My guess is 1. There is likely some large customer that wanted either their really poor OLTP system to handle 200+ keys, or there's a DW that needs this and MS gave them a large limit.

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Revenant

SSC-Forever

Points: 42467

August 27, 2018 at 10:12 am

#2003465

Elementary, dear Watson. 😉

Thanks, Steve!

Ken Hiatt SSC-Addicted Points: 469 More actions · Answer 6

I confess, I had to look this up. 253 is just the Outgoing Keys, the incoming keys have a limit of 10,000! That's a really important table to be referenced by 10,000 other tables. While I've seen incoming in the 200 range, max outgoing was maybe a dozen.
Ken

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 7

Nice question Steve, took some research as, thankfully, I have never got anywhere near this amount,

Thanks

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know