The tooltip shown for sys.dm_db_index_physical_stats is is not correct.
It says:
dm_db_index_physical_stats (@DatabaseId, @IndexId, @Mode, @ObjectId, @PartitionNumber),
while books online says:
sys.dm_db_index_physical_stats (
{ database_id | NULL | 0 | DEFAULT }
, { object_id | NULL | 0 | DEFAULT }
, { index_id | NULL | 0 | -1 | DEFAULT }
, { partition_number | NULL | 0 | DEFAULT }
, { mode | NULL | DEFAULT }
)
(the order is scrambled)
It says:
dm_db_index_physical_stats (@DatabaseId, @IndexId, @Mode, @ObjectId, @PartitionNumber),
while books online says:
sys.dm_db_index_physical_stats (
{ database_id | NULL | 0 | DEFAULT }
, { object_id | NULL | 0 | DEFAULT }
, { index_id | NULL | 0 | -1 | DEFAULT }
, { partition_number | NULL | 0 | DEFAULT }
, { mode | NULL | DEFAULT }
)
(the order is scrambled)