query: Archival strategy for a table with 25 million records in SQL Server 2008 R2 Enterprise
positive_passages.docid: 158321
positive_passages.text: SQL Server database design for "archived but available" data
negative_passages.docid: 151119
negative_passages.text: Would using varchar(5000) be bad compared to varchar(255)?
negative_passages.docid: 141127
negative_passages.text: Multiple Transaction Log files and performance impact
negative_passages.docid: 83203
negative_passages.text: Dynamic Table partitioning on a daily basis
negative_passages.docid: 125629
negative_passages.text: What storage solutions are there for working with large volumes of digital photo data?
negative_passages.docid: 35323
negative_passages.text: How do I get useful SQL Server database performance statistics?
negative_passages.docid: 39258
negative_passages.text: Storing images in SQL Server?
negative_passages.docid: 63140
negative_passages.text: SQL Server nvarchar(max) vs nvarchar(n) affects performance
negative_passages.docid: 87815
negative_passages.text: What's the best practice of inserting a collection of data into a SQL Server database
negative_passages.docid: 57139
negative_passages.text: SSD for production database
negative_passages.docid: 72229
negative_passages.text: MS Access + SQL Server for 1160 users - Is it worth it? (Please Help!)
negative_passages.docid: 59960
negative_passages.text: SQL Server Automated Backups
negative_passages.docid: 140715
negative_passages.text: Will running a large query on a secondary database in an availability group affect transaction performance in the primary database?
negative_passages.docid: 134406
negative_passages.text: Copy a large data from sql query result
negative_passages.docid: 146264
negative_passages.text: SQL Server Error 8632 due to over 100,000 entries in WHERE clause
negative_passages.docid: 129641
negative_passages.text: Simple Mode - Is using checkpoints to truncate the transaction log a bad practice?
negative_passages.docid: 140721
negative_passages.text: ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?