Scott Bruns questions

Scott Bruns answers

• Does WCF cache stored procedures
• sql: what does Max() -1 mean?
• Best Practices for displaying large lists
• How to avoid Table Locks while Inserting Data in table
• What's the best way to save trivial user states (e.g. dismissed welcome msg) in database?
• Getting SQL results in parts
• MySql COUNT(*) is different in Stored Procedure
• How to Edit a File in VS2010 & TFS w/o checking the file out
• How to achieve test isolation testing Oracle PL/SQL?
• Why is my SQL Server ORDER BY slow despite the ordered column being indexed?