When a team is developing a database application, it is a mistake to believe that deployment is a simple task.
Multi-line SQL String Literals in C# Back in September there were a couple of unrelated blog posts that used literal multi-line SQL strings as examples to illustrate two different points. The first by David Cumps investigated the performance aspects of string concatenation vs. memory allocation . The second by Chinh Do presented a number of Visual Studio 2005 IDE tips and tricks , one of which was the use of regular expressions in the find and replace dialog.
SQL Query Optimization FAQ Part 1 (The SQL Plan) 1) Introduction and Goal 2) What is a SQL execution Plan? 3) Can we understand step by step how SQL Query plan is created and executed?