Scott Bruns questions

Scott Bruns answers

• Scenario where one should use Read committed or Serializable as Isolation level?
• 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?