July 2008 - Posts

• Optimizing queries with joins and over statements in SQL 2005

  I was working on a common scenario and found an interesting side effect. Applications typically have a listing page that get search criteria from a UI and passes to a stored procedure. In the procedure you often find statements like: SELECT a , b , c Read More... Posted Tuesday, July 29, 2008 12:27 AM by mab | 1 Comments Filed under: SQL Server