SQL Server Brain Basher of the Week #024 - Partitioning

Here is the this week Brain Basher.

How many partitions can be created per table or index with SQL Server 2014?

1) 256

2) 1,000

3) 1,024

4) 15,000

There are two answers for this based on SQL Server architecture. If the installed system is 32-bit SQL Server instance, 1,000 partitions can be created per table or index. If it is 64-bit, then 15,000 partitions can be created.