Sunday, July 10, 2011

How many?

How many instances per computer?

50 instances on stand-alone server.
25 instances on failover cluster.

How many Non-Clustered indexes per table?

999

How many Parameters per stored procedure?

2100

How many Parameters per user-defined function?

2100

How many Nested triggers/stored procedures levels?

32

How many columns per SELECT/INSERT statement?

4096

How many columns per PRIMARY/Foreign KEY?

16

Links

No comments:

Post a Comment