2
Does It Do It?
The behavior in newer versions of SQL Server is that the partitioning kicks in dynamically as certain thresholds are crossed. I don't have access to those calculations, so I can't tell you when it will kick in.
The problem is that you may still need 8048 for it to be the overall default behavior, since you may run into scenarios where you get ...
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2012 × 4471sql-server × 3231
performance × 275
t-sql × 260
availability-groups × 244
sql-server-2008 × 179
sql-server-2008-r2 × 169
backup × 161
sql-server-2014 × 130
ssms × 127
permissions × 112
replication × 111
restore × 95
ssis × 94
query-performance × 93
index × 90
clustering × 85
transaction-log × 84
security × 82
sql-server-agent × 79
stored-procedures × 77
memory × 75
execution-plan × 73
sql-server-2016 × 70
windows-server × 69