Scott Bruns questions

Scott Bruns answers

• 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?
• Branch by feature - Advantages/disadvantages?
• Why does select max(field) from table work so fast as compared to select min(field) from table, Oracle 9i
• The most efficient sql schema for searching names and lastnames