Brad Marsh alerts us to this handy option in SQL Server 2008 – how to change the default result set sizes. They default to 200 for Edit and 1000 for Select, but can be increased to… everything if desired. Proceed with caution though – there’s a reason Microsoft put these new limits in.
TIP: SQL Server 2008 – changing default ‘Edit Top 200 rows’
T
Hi,
“Proceed with caution though – there’s a reason Microsoft put these new limits in.”
Why’s that then?
Hi,
“Proceed with caution though – there’s a reason Microsoft put these new limits in.”
Why’s that then?
The reason they were put in is because it was too easy to ‘accidentlly’ pull back entire tables – which can be resource intensive on large tables. So, if you reset these, be careful – you may be opening the door to unnecessary resource hits on SQL.
The reason they were put in is because it was too easy to ‘accidentlly’ pull back entire tables – which can be resource intensive on large tables. So, if you reset these, be careful – you may be opening the door to unnecessary resource hits on SQL.