Patrick Marchand questions

Patrick Marchand answers

• SQL Server OpenQuery() behaving differently then a direct query from TOAD
• Oracle SQL - group by char cast
• What is the relationship between blocking, locking, and isolation levels?
• How do I get Oracle, see what procedures are running?
• DELETE SQL with correlated subquery for table with 42 million rows?
• How do you get the next value in a sequence into a variable?
• SQL: Group By on Consecutive Records
• SSIS 2005: "Append rows to the destination table" is greyed out. Why?
• How are bitmap indexes helpful?