SQL Server Management Articles

Change Select Top 1000 Rows value in SSMS

One seemingly minor change to SQL Server Management Studio (SSMS) in SQL Server 2008 is that by default it will only allow the visually select the top 1000 rows . This is primary to save on memory which can be drained by loading numerous rows into the SSMS visual editor. If, however, you don’t want […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |