I was troubleshooting a deadlock the other day and it got me thinking…. I know the number 1205 by heart and know it is associated to a deadlock. What other numbers are there that you can associate to an event or object or limitation. For example 32767 will be known by a lot of people as the database id of the ResourceDb, master is 1, msdb is 4 etc etc.
So below is a list of numbers I thought of
Leave me a comment with any numbers that you know by heart
BTW I didn’t do the limits for int, smallint etc etc, those are the same in all programming languages…so not unique to SQL Server
Read on for Denis’s list.